PL/SQL   «Prev 

Querying a Varray Example in Oracle

SELECT phone_list
FROM customer_obj_table
WHERE cust_id = 26;

Location 1 The SELECT clause with phone_list (a varray column)
Location 2 The FROM clause containing customer_obj_table
Location 3 The WHERE clause to select specific records