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 vote218 views1 answer
Netstat -tln mysql
SQL
0 vote199 views1 answer
Incorrect datetime value sql table error 1292
SQL
2 votes193 views1 answer
Laravel sql String
SQL
0 vote204 views1 answer
Oracle sql all days except weekends
SQL
1 vote200 views1 answer
ALL_TAB_PARTITIONS
SQL
5 votes186 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote194 views1 answer
Oracle temporary table
SQL
3 votes192 views1 answer
Convert sqlite table to pandas dataframe
SQL
-1 vote180 views1 answer
How to format tables in sqlplus
SQL
0 vote189 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL