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 vote356 views1 answer
Select milliseconds mysql
SQL
0 vote328 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote303 views1 answer
Mysql group rows with same value
SQL
1 vote373 views2 answers
Oracle leftmost characters
SQL
-1 vote361 views1 answer
Pl sql drop trigger
SQL
0 vote320 views1 answer
Oracle show running job
SQL
1 vote331 views1 answer
Sysdate in sql
SQL
0 vote346 views4 answers
User defined function sql
SQL
22 votes322 views3 answers
Sql cheat sheet
SQL
3 votes313 views1 answer
Oracle user quota unlimited
SQL