Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to know the latest sequence number?
Hi everyone,
I use a sequence's next value as table's primary key to append a record. After that, how can I know what that number is?
insert into Contact (contact_id, contact_name) values (contact_seq.nextval, in_contact_name)
then I want to know what is the contact_id I just used?
Thanks,
Bill
Received on Thu Jan 17 2002 - 03:48:09 CST