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 vote124 views9 answers
Linq to sql converter online
SQL
0 vote123 views1 answer
Pagination with row_number
SQL
12 votes190 views4 answers
How to drop all tables in postgresql
SQL
1 vote132 views2 answers
Mysql remove first and last character from string
SQL
13 votes150 views2 answers
Oracle inner join
SQL
8 votes122 views1 answer
Oracle find text in functions
SQL
2 votes124 views1 answer
How to check if a row is null in sql
SQL
0 vote133 views1 answer
Drop view in mysql
SQL
17 votes121 views6 answers
Mysql import sql file
SQL
0 vote162 views1 answer
Install postgresql 12 on debian 10
SQL