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

4 votes333 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote340 views1 answer
Mysql query problems and solutions
SQL
1 vote316 views1 answer
Input in mysql
SQL
-1 vote354 views1 answer
Round up and down sql
SQL
4 votes325 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote355 views2 answers
Oracle create tablespace autoextend
SQL
8 votes350 views3 answers
Connect python to mysql
SQL
1 vote325 views1 answer
Set mysql mode global query
SQL
0 vote333 views1 answer
Multiple tricky query in sql server
SQL
0 vote364 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL