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 vote143 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
2 votes149 views1 answer
Drop all database tables oracle sql developer
SQL
-2 votes142 views1 answer
How to open database
SQL
0 vote138 views1 answer
Sql server manager close connection
SQL
0 vote143 views1 answer
Sql case when exists in another table
SQL
0 vote160 views1 answer
Mysql remove bad character from all fields
SQL
0 vote140 views1 answer
Suse start MySQL
SQL
0 vote160 views1 answer
Sintaxis SELECT sql
SQL
0 vote227 views1 answer
Mssql unique key accept nulls
SQL
2 votes140 views1 answer
Mysql set value as null
SQL