INSERT TWO ROWS INTO THE ORDERS TABLE, EXPLICITLY PROVIDING THE COLUMN NAMES

4. Insert two rows into the ORDERS table, explicitly providing the column

names:

insert into orders (order_id, order_date, order_status, order_amount, customer_id)

values (order_seq.nextval, sysdate, 'COMPLETE', 3, 2);

values (order_seq.nextval, sysdate, 'PENDING', 5, 3);