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

7 votes224 views6 answers
Nth highest salary in sql
SQL
16 votes229 views6 answers
Install sqlite3 python
SQL
0 vote224 views2 answers
Python mysql create table if not exists
SQL
13 votes234 views4 answers
Command line mysql import
SQL
32 votes213 views6 answers
Sql count where
SQL
2 votes221 views1 answer
Can you use a where clause for a child query
SQL
0 vote236 views1 answer
Oracle webcenter content search enginer
SQL
0 vote212 views2 answers
Null value in column violates not-null constraint
SQL
1 vote198 views1 answer
How to get mysql db size
SQL
0 vote241 views2 answers
Mysql show foreign keys
SQL