Pl sql example

Pl sql

# just don't do it

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 vote111 views1 answer
How to find username and password in oracle 18c
SQL
0 vote115 views1 answer
Can't connect to postgresql mac os
SQL
0 vote120 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote118 views1 answer
Table information in sql server
SQL
1 vote125 views1 answer
Psql import backup file for windows
SQL
0 vote119 views1 answer
Sql server select ignore dupplicates
SQL
0 vote112 views1 answer
Rabbitmq service not starting
SQL
12 votes104 views5 answers
Sql merge
SQL
0 vote123 views1 answer
Sql search all columns of database oracle sql
SQL
2 votes131 views1 answer
How to create sql database
SQL