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 vote161 views1 answer
How to check default value of column in sql server
SQL
3 votes157 views2 answers
How to start postgresql on windows
SQL
0 vote164 views1 answer
Distance calculator from lat long sql query
SQL
0 vote137 views1 answer
Metada in sql
SQL
-1 vote148 views2 answers
Postgres autoincrement primary key
SQL
0 vote158 views1 answer
Change magento database url usimg musql
SQL
0 vote158 views1 answer
Mysql get last 2 month data
SQL
0 vote150 views1 answer
Sql DATE = GETDATE()
SQL
5 votes186 views1 answer
How to use rank function in sql
SQL
1 vote149 views6 answers
In sql
SQL