VARRAY
[CREATE [OR REPLACE]] TYPEtype_nameIS VARRAY | VARYING ARRAY (max_elements) OFelement_type[NOT NULL];
A singly dimensioned, bounded collection of homogeneous elements available in both PL/SQL and the database. VARRAYs (variable arrays) are always bounded and never sparse. Unlike nested tables, their element order is preserved when you store and retrieve them from the database.
Keywords
- type_name
Any valid identifier that will be used later to declare the collection.
- max_elements
Maximum number of elements for this VARRAY.
- element_type
Type of the collection’s elements. All elements are of a single type, which can be most scalar datatypes, an object type, or a REF object type. If the elements are objects, the object type itself cannot have an attribute that is a collection. Explicitly disallowed collection datatypes are BOOLEAN, NCHAR, NCLOB, NVARCHAR2, REF CURSOR, TABLE, and VARRAY.
- NOT NULL
Indicates that a collection of this type cannot have any NULL elements. However, the collection can be atomically NULL (uninitialized).