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

10 votes303 views4 answers
SELECT FROM WHERE
SQL
1 vote300 views1 answer
Select users with same username
SQL
0 vote291 views1 answer
Rename constraint postgresql
SQL
0 vote282 views2 answers
Postgres having
SQL
0 vote236 views1 answer
Sql new line output
SQL
0 vote289 views2 answers
How to install mssql on mac
SQL
0 vote278 views1 answer
Oracle activate program
SQL
4 votes269 views2 answers
Mysql select where starts with
SQL
1 vote274 views2 answers
Sql left characters
SQL
1 vote297 views1 answer
Date in where on datetime column clause mysql
SQL