¡¼¿¹Á¦¡½
SQL> select employees_seq.nextval from dual;
NEXTVAL
----------
207
SQL> insert into employees
2 values (employees_seq.nextval, 'John', 'Doc', 'jdoe',
3 '555-1212', TO_DATE(SYSDATE), 'PU_CLERK', 2500, null, null, 30);
1 row created.
SQL> insert into orders (order_id, order_date, customer_id)
2 values (orders_seq.nextval, TO_DATE(SYSDATE), 106);
SQL> insert into order_items (order_id, line_item_id, product_id)
2 values (orders_seq.currval, 1, 2359);
SQL> insert into order_items (order_id, line_item_id, product_id)
2 values (orders_seq.currval, 2, 3290);
SQL> insert into order_items (order_id, line_item_id, product_id)
2 values (orders_seq.currval, 3, 2381);
SQL>