To query on all the details of a record within an object table associated with a varray, you must query the varray. To do so, include the varray column name within the SQL statement. In this lesson, we will look at the simplest way to query a varray within an object table. A varray is always associated with an object table.
The simplest way to query a varray is by selecting the varray name within a simple SELECT statement.
This, in turn, will display all the elements within the varray.
The following diagram explains the syntax:
The SELECT clause containing a varray column
The FROM clause containing the table name for the object table
The WHERE clause to select specific records
SELECT <varray_name>
FROM table_name
WHERE <condition for selection>;