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

2 votes178 views1 answer
Username sql
SQL
0 vote155 views2 answers
Collation in sql
SQL
0 vote133 views1 answer
Oracle simple quote
SQL
1 vote162 views3 answers
Postgresql get difference between two dates
SQL
0 vote148 views1 answer
Is not sql
SQL
0 vote131 views1 answer
Sql get month from date
SQL
2 votes156 views1 answer
Postgresql transaction
SQL
4 votes150 views1 answer
Sql quote in string
SQL
0 vote173 views1 answer
Mysl like insert a variable
SQL
0 vote152 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL