The SELECT statement for selecting a particular record from the parent table
The SET clause to update the value within a nested table
The WHERE clause to select a particular row of the nested table
What is a VARRAY?
VARRAY stands for variable-size array. It is an array that can be either manipulated as a whole or individually as elements.
It has a maximum size and can contain 0 to any number of elements up to the maximum specified.
VARRAY is stored in-line and that means the data of a column of VARRAY type is stored along with the remaining data of the row.
You can use VARRAY data type for: