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 vote276 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote1.1K views1 answer
Mysql custom sort order
SQL
0 vote304 views1 answer
Connect laravel to mysql on mac
SQL
1 vote300 views4 answers
Sql now
SQL
0 vote320 views1 answer
Postgres can integer fields be negative
SQL
0 vote301 views1 answer
How to select a row in sql
SQL
13 votes294 views5 answers
Sql default
SQL
0 vote279 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote299 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote271 views1 answer
Procedures and functions in pl/sql
SQL