PL/SQL   «Prev  Next»

Querying Nested Tables in Oracle

  1. First, query a nested table that has a reference operator (REF).
  2. After completing the required entry fields to connect to the database, you completed the following steps:
  3. You queried the table by building the following SQL string:

SELECT DEREF(a.product_id), item_qty, detail_amount 
FROM THE 
(SELECT detail_nest 
FROM sale_header 
WHERE sale_id = 34) a;

  1. After the process is completed, SQL*Plus displays the result of the compilation of your query.