Re: how to know the latest sequence number?

From: fred <ommerbornf_at_free.fr>
Date: Thu, 17 Jan 2002 10:57:28 +0100
Message-ID: <3c46a0a8$0$211$626a54ce@news.free.fr>

Look at the currval

Just after invoking a nextval you may look at the current value of the sequence whith currval.

Sorry for my poor english.
Best regards.
Fred

"Bill Han" <billxhan_at_hotmail.com> a écrit dans le message news: t5x18.7616$467.301188_at_news2.calgary.shaw.ca...
> 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:57:28 CST