RelationalDBDesignRelationalDBDesign


PL/SQL   «Prev 

Querying a Flattened Varray Syntax in Oracle

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