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: