Table Modification   «Prev 

Syntax for Inserting Rows in a Table

INSERT INTO <table_name> 
VALUES (<non REF column values>, (SELECT REF (table alias) from <table_name> alias
WHERE <clause>), <other non-REF column values> );

Location 1 The INSERT statement specifying the table
Location 2 The values of the columns in the order of the definition of columns during object table creation
Location 3 The sub query to select reference data
Location 4 The other column data
Location 5 The end of the INSERT statement