Pl sql

# just don't do it

Print in pl sql

dbms_output.put_line("YOUR MESSAGE");

PL/SQL

DECLARE
TYPE <type_name> IS RECORD
(
<columnl> <datatype>,
);
BEGIN
<execution_section>;
END;

Source: guru99.com

Pl sql example

DECLARE
  CURSOR cursor_person IS
    SELECT person_code FROM people_table;
BEGIN
  FOR RecordIndex IN cursor_person
  LOOP
    DBMS_OUTPUT.PUT_LINE(recordIndex.person_code);
  END LOOP;
END;

Source: en.wikipedia.org

Similar codes

11 votes169 views1 answer
Oracle insert from select
SQL
0 vote126 views1 answer
How to check foreign key constraint in sql
SQL
0 vote56 views1 answer
Check sql query executed wp
SQL
0 vote105 views1 answer
Logtash mysql cofiguration file
SQL
0 vote55 views1 answer
Get last run query sql server
SQL
0 vote110 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
17 votes102 views2 answers
How to assign date field for table in mysql
SQL
2 votes109 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote97 views1 answer
Sql query interview questions githu
SQL
46 votes167 views4 answers
Create column sql
SQL