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 vote288 views1 answer
Oracle sql all days except weekends
SQL
2 votes190 views1 answer
Enum in SQL Server
SQL
4 votes174 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote180 views1 answer
Sql server port 1434
SQL
3 votes309 views1 answer
Ssh check mysql version
SQL
11 votes362 views4 answers
Round in sql
SQL
1 vote151 views1 answer
Psql kill pid
SQL
0 vote189 views2 answers
Close external port 3306 with iptables
SQL
0 vote189 views1 answer
Java nosql sort
SQL
1 vote207 views1 answer
Mysql Case sum
SQL