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 vote274 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote223 views1 answer
Sql new line output
SQL
0 vote272 views1 answer
Select insert new table sql server
SQL
0 vote276 views1 answer
Oracle query to find schema you are working on
SQL
0 vote275 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
2 votes275 views1 answer
Cast string to datetime mysql
SQL
0 vote254 views1 answer
Convert sql server guid to varbinary
SQL
0 vote283 views1 answer
T sql dynamic top n query
SQL
0 vote259 views1 answer
H2 auto increment and unique
SQL
1 vote254 views1 answer
Primary key reset in SQL database
SQL