Querying Flattened varray [Example]

Querying Flattened varray Example

SELECT VALUE (a) FROM THE 
  (SELECT phone_list FROM customer_obj_table
	WHERE cust_id = 29) ;

Location 1	The first `SELECT` clause
Location 2	The second `SELECT` clause
Location 3	The second `SELECT` clause

Nested tables support a great variety of queries. A nested table is a column within a table. To support queries of the columns and rows of a nested table, Oracle provides a special keyword, THE (which has been deprecated for some time). To see how the THE keyword is used, first consider the nested table by itself. If it were a normal column of a relational table, you would be able to query it via a normal select command.