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 vote170 views1 answer
Sql server order by nulls last
SQL
0 vote400 views1 answer
Sql datum formatieren
SQL
6 votes232 views3 answers
Mysql change auto_increment start value
SQL
-1 vote207 views1 answer
Create view in mysql workbench
SQL
3 votes173 views5 answers
Mysql get last inserted id
SQL
0 vote156 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote210 views1 answer
Select top 3 sql
SQL
0 vote170 views1 answer
Convert rows to columns in sql server
SQL
0 vote168 views1 answer
Mysql find missing values
SQL
0 vote193 views1 answer
Safe mysql
SQL