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

1 vote274 views1 answer
Mysql f# examples
SQL
2 votes276 views1 answer
Get first n letter of department name in sql
SQL
4 votes277 views3 answers
Order by value mysql
SQL
2 votes308 views3 answers
Row number mysql
SQL
0 vote295 views1 answer
How to delete python anywhere mysql database
SQL
0 vote283 views1 answer
Mysql where in keep order
SQL
0 vote300 views1 answer
Mysql remove bad character from all fields
SQL
5 votes285 views1 answer
Oracle nls instance
SQL
0 vote270 views1 answer
Mysql add to value
SQL
27 votes338 views3 answers
Mysql delete row
SQL