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 vote221 views1 answer
Insert into table with only identity column
SQL
0 vote183 views4 answers
How to drop all tables in sql
SQL
0 vote181 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
3 votes181 views1 answer
Oracle function
SQL
0 vote187 views1 answer
Install ms sql server management studio
SQL
0 vote216 views1 answer
Yesql
SQL
0 vote197 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote193 views1 answer
Pgadmin see indexes
SQL
0 vote208 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote213 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL