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

4 votes367 views1 answer
Mysql ip address data type
SQL
9 votes346 views1 answer
Oracle get table schema
SQL
0 vote349 views1 answer
Where case insensitive like mysql
SQL
9 votes387 views3 answers
Postgres make sql dump
SQL
1 vote410 views1 answer
Delete dublicate rows sql
SQL
0 vote372 views1 answer
Sql server create constraint
SQL
2 votes387 views1 answer
Sql server check for value in multiple columns
SQL
1 vote362 views1 answer
Find difference in dates sql
SQL
4 votes450 views4 answers
Remove duplicate old value in mysql
SQL
1 vote364 views1 answer
Delete specific row in sql
SQL