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 |