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

1 vote248 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote232 views1 answer
Sqlite commands
SQL
0 vote236 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote235 views1 answer
Output table plsql
SQL
44 votes246 views6 answers
Rename command in sql
SQL
2 votes241 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote259 views1 answer
Ajouter une clé etrangere mysql
SQL
2 votes259 views2 answers
Create temporary table in mysql
SQL
0 vote241 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes274 views2 answers
Truncate table
SQL