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 vote143 views2 answers
What is the default password for sql server sa
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote94 views1 answer
Into sql
SQL
0 vote109 views1 answer
Separator mysql
SQL
0 vote130 views1 answer
Print mysql
SQL
2 votes137 views1 answer
Oracle to_char number format percentage
SQL
3 votes148 views2 answers
Sqlite show table definition
SQL
1 vote125 views1 answer
Mysql login console
SQL
12 votes158 views1 answer
Create column sql server
SQL
5 votes141 views1 answer
How to use rank function in sql
SQL