CURRVAL pseudocolumn
 
¡¼¿¹Á¦¡½
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>