5-autoincrement.txt

-INSERT INTO book VALUES(book_seq.NEXTVAL,Java,69.00,20);INSERT INTO book VALUES(book_seq.NEXTVAL,Oracle,42.30,124);INSERT INTO book VALUES(book_seq.NEXTVAL,F,38.40,56);SELECT * FROM book;INSERT INTO orders (id,create_time)VALUES(order_seq.NEXTVAL,SYSDATE);SELECT * FROM orders;INSERT INTO orderitem VALUES(item_seq.NEXTVAL,1,69.00,5,1);INSERT INTO orderitem VALUES(item_seq.NEXTVAL,3,38.40,10,1);SELECT * FROM orderitem;