PL/SQL Cursors

Cursor is nothing but a pointer to result of a SQL query.

• Implicit/Explicit Cursors
• Cursor Variable – Ref Cursors (Strong & Weak Type)

Database schema used for SQL query: Customer Order Schema Cursor Blog1 Cursor Blog2

PL/SQL Records

Record is composite data structure i.e. composed of one or more fields.

• Table Based/Cursor Based/User Defined Records

PL/SQL Collections (Data Structures)

VARRAY

Similar to array in other programming languages.

• Declare, Initialize & Iterate
• Adding & Removing Elements
• Varray as Database Table Column
• Composite Datatype Varray

Associative Array

Similar to hash tables in other programming languages like Dictionary in Python. PL/SQL Associative arrays are set of Key-Value pair.

• Associative Array Examples

---