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 |