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

0 vote149 views1 answer
T sql dynamic top n query
SQL
3 votes139 views2 answers
Sql select data from last week
SQL
0 vote224 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote120 views1 answer
Minus equivalent in my sql
SQL
1 vote135 views2 answers
Sql where keyword
SQL
0 vote164 views1 answer
Mysql bind-address default value
SQL
0 vote128 views1 answer
Vowels in sql
SQL
0 vote133 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote131 views1 answer
Azure sql server check foreign key
SQL
-1 vote88 views1 answer
Oracle db list usernames
SQL