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 vote294 views1 answer
Sql developer export connections
SQL
0 vote180 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote156 views1 answer
Rollback to name in sql
SQL
0 vote181 views2 answers
Postgres having
SQL
11 votes171 views3 answers
Sqlite3 create table from another table
SQL
3 votes158 views1 answer
Oracle undo tablespace list by user
SQL
6 votes541 views3 answers
Sql select last id
SQL
0 vote181 views1 answer
Ignore case in string sql
SQL
11 votes180 views2 answers
Having in sql
SQL
0 vote176 views1 answer
Mysql match in serialized data
SQL