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

1 vote211 views1 answer
Last 24 HOUR data in mysql
SQL
5 votes188 views1 answer
Sqlite alter table add column
SQL
1 vote237 views2 answers
Select into temp table
SQL
3 votes204 views2 answers
Oracle apex view logs
SQL
0 vote234 views1 answer
Count column of tables psql
SQL
0 vote204 views1 answer
Mysql custom sort order
SQL
0 vote192 views1 answer
Test the postgresql db connection
SQL
-1 vote132 views2 answers
Datetime sql server week
SQL
3 votes176 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote190 views1 answer
Oracle rolling back transactions
SQL