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 vote99 views3 answers
Get free card roblox
SQL
0 vote118 views1 answer
SQL Error 1040 : Too many connections
SQL
2 votes108 views1 answer
Sql missing records from another table
SQL
0 vote120 views1 answer
Mysql get first 2 characters of string
SQL
2 votes99 views1 answer
Plsql block
SQL
0 vote174 views1 answer
How to get number of months between 2 dates sql server
SQL
65 votes267 views6 answers
Sql add column to table
SQL
0 vote112 views3 answers
Java hide mysql login credentials
SQL
0 vote113 views1 answer
Sql server delete records with specific date
SQL
-1 vote58 views3 answers
Ubuntu install mssql
SQL