Figure 1: INSERT on FROM example

CREATE TABLE orders (order_id INTEGER AS IDENTITY,

                     order_date DATE,

                     order_qty INTEGER,

                     order_item CHAR(4));



SELECT order_id FROM FINAL TABLE (

  INSERT INTO orders VALUES(DEFAULT, '11/03/2007' , 50, 'JM12') );



SELECT order_id FROM FINAL_TABLE (

  INSERT INTO orders VALUES(DEFAULT, '11/05/2007', 12, 'JM09') ,

                           (DEFAULT, '11/05/2007',  1, 'PC01'))

ORDER BY INPUT SEQUENCE;