Querying Nested Tables in Oracle
- First, query a nested table that has a reference operator (REF).
- After completing the required entry fields to connect to the database, you completed the following steps:
- You queried the table by building the following SQL string:
SELECT DEREF(a.product_id), item_qty, detail_amount
WHERE sale_id = 34) a;
- After the process is completed, SQL*Plus displays the result of the compilation of your query.