VARRAY

1.   A VARRAY in Oracle is a collection type that stores a fixed-size, ordered set of elements, all of the same data type.

2.   The maximum number of elements in a VARRAY must be specified at the time of its declaration, and it cannot exceed that limit.

3.   VARRAYs are dense collections, meaning they always maintain sequential indexes starting from 1, with no gaps.

4.   VARRAYs can be stored in database tables as a column, making them persistent and usable in SQL queries.

5.   They are ideal for storing small to medium-sized lists of related data because their maximum size is predefined and limited.

6.   VARRAY elements can be of any valid SQL or PL/SQL data type, including user-defined types, and they can also contain nested collections.

7.   When a VARRAY is returned from a PL/SQL function, it preserves the order of elements as inserted, unlike associative arrays which are unordered.

8.   You can initialize a VARRAY using the constructor function with values enclosed in parentheses, e.g., VARRAY_TYPE(1, 2, 3).

9.   Access to VARRAY elements is done using a numeric index, starting at 1, and elements can be updated or replaced individually.

10.  VARRAYs consume contiguous memory, so operations like extending or deleting elements are less flexible than nested tables, but they offer faster access to stored elements.