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 vote334 views1 answer
Oracle exchange subpartition
SQL
0 vote312 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote316 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote275 views8 answers
Convert sql query to linq online
SQL
0 vote327 views1 answer
Oracle date winter time
SQL
11 votes320 views3 answers
Change column name sql server management studio
SQL
0 vote317 views1 answer
Populate db from command line postgres
SQL
0 vote362 views1 answer
Mysql create index lost connection
SQL
0 vote370 views1 answer
Sql alternative to max statement
SQL
0 vote314 views1 answer
Convert int to varchar sql
SQL