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 vote305 views1 answer
Addition of 2 column value in mysql
SQL
0 vote319 views2 answers
Postgresql gset
SQL
-1 vote245 views3 answers
Ubuntu install mssql
SQL
0 vote316 views1 answer
Postgres row expiration
SQL
0 vote305 views1 answer
Reset postgresql password windows
SQL
0 vote315 views1 answer
Like date sql server not working
SQL
0 vote304 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote330 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
6 votes294 views3 answers
Mysql first day of year
SQL
0 vote291 views1 answer
How to get all values in a table mysql in c#
SQL