SQL*Loader supports loading of the following two collection types:
A nested table is a table that appears as a column in another table. All operations that can be performed on other tables can also be performed on nested tables.
VARRAY is a variable sized arrays. An array is an ordered set of built-in types or objects, called elements. Each array element is of the same type and has an index, which is a number corresponding to the element's position in the
When you create a
VARRAY type, you must specify the maximum size. Once you have declared a
VARRAY type, it can be used as the data type of a column of a relational table, as an object type attribute, or as a PL/SQL variable.
"Loading Collections (Nested Tables and VARRAYs)" for details on using SQL*Loader control file data definition language to load these collection types