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 vote140 views1 answer
Asp.net core sql server stored procedure
SQL
3 votes141 views2 answers
Mysql update row
SQL
0 vote139 views1 answer
Oracle current timestamp insert statement
SQL
2 votes190 views1 answer
Oracle block
SQL
0 vote112 views1 answer
Postgres create database if not exists
SQL
0 vote152 views1 answer
How to print sql query
SQL
0 vote155 views1 answer
Dockerfile example for Django
SQL
0 vote125 views1 answer
Get who is hired in month in sql
SQL
0 vote143 views2 answers
Identity syntax in sql
SQL
0 vote142 views1 answer
Mysql DDL
SQL