Inserting Data into Nested Table (Example)

INSERT INTO TABLE (SELECT s.detail_nest FROM 
  SALE_HEADER s
  WHERE s.sale_id =36)
SELECT REF(P), 200, 56
FROM PRODUCT_OBJ_TABLE p
WHERE product_id =21;

Inserting data into a nested table example

Location 1	The `INSERT` statement with the `TABLE` keyword
Location 2	The `SELECT` statement for selecting a particular record from the parent table
Location 3-5	The sub query to select reference and other column data