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

2 votes176 views1 answer
Mysql sysdate
SQL
1 vote280 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote201 views1 answer
Postgresql in vs any performance
SQL
-2 votes192 views2 answers
Sqlserver docker
SQL
0 vote184 views1 answer
T-sql email validation
SQL
0 vote189 views2 answers
Sql join on comma separated field
SQL
0 vote218 views1 answer
List all permissions on a table in postgres
SQL
16 votes253 views4 answers
Find duplicates mysql
SQL
1 vote217 views1 answer
Sql order by timestamp
SQL
12 votes245 views10 answers
Google
SQL