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 vote185 views1 answer
Normalization in database
SQL
4 votes172 views3 answers
Oracle sql first day of quarter
SQL
0 vote127 views1 answer
Sql query with date
SQL
11 votes234 views2 answers
Docker create postgres db
SQL
1 vote182 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote184 views1 answer
Get who is hired in february in sql
SQL
0 vote191 views1 answer
Time mysql w3
SQL
4 votes268 views4 answers
Update select mysql
SQL
2 votes193 views1 answer
Where clause for child record apex
SQL
1 vote203 views1 answer
Hangfire clear all jobs
SQL