RelationalDBDesignRelationalDBDesign


PL/SQL   «Prev 

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.