Getting value of auto increment key field

serogole · #1 (**permalink**) 02-16-04, 14:24

I am sure this has been done many times: I have an auto increment key field, say order_No, and on inserting an order I need to know the value of order_no so I can insert order lines linked to the order. How do I retrieve this value? I am already thinking about work-arounds like keeping the numbers in a separate table.
Best Regards

ss659 · #2 (**permalink**) 02-16-04, 15:14

Quote:

Originally posted by serogole
I am sure this has been done many times: I have an auto increment key field, say order_No, and on inserting an order I need to know the value of order_no so I can insert order lines linked to the order. How do I retrieve this value? I am already thinking about work-arounds like keeping the numbers in a separate table.
Best Regards

Select seq_name.currval
from dual;