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

5 votes291 views2 answers
Mysql where in array
SQL
0 vote299 views1 answer
Increment id in mysql
SQL
2 votes318 views1 answer
How to find constraints on a table in oracle
SQL
0 vote275 views1 answer
Print sum of values sql
SQL
26 votes316 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote300 views2 answers
Sql where keyword
SQL
0 vote298 views1 answer
Mysql select where text contains
SQL
-1 vote334 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote296 views1 answer
MySQL error code 2068
SQL
0 vote327 views1 answer
Mysql cli output to a file
SQL