SELECT VALUE(table_alias) FROM THE (SELECT <varray_name> from <object_table_name> WHERE <condition for selection>) table_alias;
| Location 1 | The first SELECT clause, containing a value of the table alias |
| Location 2 | The second SELECT clause, containing the varray name within the object table to select specific records |
| Location 3 | The second SELECT clause, containing the varray name within the object table to select specific records |