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 vote173 views2 answers
Generate sql trigger through ef migration
SQL
1 vote226 views1 answer
Oracle check table lock
SQL
0 vote164 views1 answer
Postgres week number
SQL
9 votes169 views2 answers
Nosql databases
SQL
0 vote174 views1 answer
Contact mysql column field
SQL
1 vote167 views1 answer
Psql filed name alter
SQL
14 votes180 views2 answers
Oracle export trigger ddl
SQL
0 vote136 views1 answer
Mysql select top 2
SQL
0 vote174 views1 answer
Group by join columns per table
SQL
0 vote247 views1 answer
SQL check if record exist
SQL