Composite types have internal components that can be manipulated individually, such
as the elements of an array, record, or table.
Oracle TimesTen In-Memory Database supports the following composite data types:
- Associative array (index-by table)
- Nested table
Associative arrays, nested tables, and varrays are also referred to as collections.
The following sections discuss the use of composite data types:
- Using collections in PL/SQL
- Using records in PL/SQL
- Using associative arrays from applications
A composite variable has internal components, which you can access individually.
You can pass entire composite variables to subprograms as parameters.
PL/SQL has two kinds of composite variables, collections and records