PL/SQL   «Prev 

Inserting Data into Nested Table (Example)

Inserting data into a 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