Oracle PL/SQL - PL SQL Data Type Collection Types

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Data Type
  4. Collection Types

Introduction

PL/SQL has three collection types:

  • associative array,
  • VARRAY (variable-size array), and
  • nested table.

Here is the mapping between the data structure name from other languages and the PL/SQL Collection Types.

Non-PL/SQL Composite TypeEquivalent PL/SQL Composite Type
Hash table Associative array
Unordered tableAssociative array
SetNested table
BagNested table
Array VARRAY

Related Topics