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 vote287 views1 answer
Setval pgsql
SQL
1 vote274 views1 answer
Mysql stop password policy
SQL
0 vote266 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
7 votes275 views2 answers
Execute mysql file
SQL
6 votes261 views1 answer
Allsource oracle
SQL
0 vote255 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
3 votes261 views1 answer
Mysql load sql from file
SQL
11 votes269 views2 answers
Having in sql
SQL
16 votes281 views1 answer
Sql comment'
SQL
0 vote279 views1 answer
Sql server list user permissions
SQL