Flattening Nested Table[Oracle Sample Code]

Flattening Nested Table in Oracle

SELECT product_id, item_qty, detail_amount
  FROM THE (SELECT detail_nest 
    FROM sale_header
    WHERE sale_id =22)
WHERE detail_amount=78;

Location 1	The `SELECT` clause for selecting attributes (that is, columns) from the nested table
Location 2	The `FROM THE` clause for specifying details of the outer table
Location 3	The second `SELECT` clause to select the nested table column (`detail_nest`) from `sale_header` (the outer table)
Location 4	The `FROM` clause to select `sale_header` (the outer table)
Location 5	The `WHERE` clause to select a particular row from `sale_header`, the outer table
Location 6	The `WHERE` clause to select a particular row from the inner table