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

3 votes119 views4 answers
Show columns from table
SQL
0 vote161 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote175 views1 answer
Modifier une valeur sql
SQL
0 vote186 views1 answer
How convert into in in sql query
SQL
2 votes207 views1 answer
Mysql shell insert into
SQL
0 vote161 views1 answer
Order by ip address sql
SQL
0 vote229 views1 answer
Restart serial number for postgres
SQL
10 votes180 views6 answers
Between sql
SQL
0 vote250 views1 answer
Sql to search who modified
SQL
13 votes163 views6 answers
Mysql update from select
SQL