SV: Getting sequence.currval

From: Kjetil Nordstrand <get.lost_at_you.spamming.bum>
Date: Wed, 28 Feb 2001 00:40:04 +0100
Message-ID: <UQWm6.5062$hi2.14739_at_nntpserver.swip.net>


You probably don't want to use currval in your insert statement, but rather nextval. The answer to your question is "select sequence.currval from dual;".

/Kjetil

"Klaus Kloos" <Klaus.Kloos_at_kagi.com> skrev i meddelandet news:1epi1g8.1o88u8q1lily00N%Klaus.Kloos_at_kagi.com...
> Hello
>
> How can I get the currval of a sequence using SQL?
> Ive not problem using "INSERT INTO table(field1) values
> (sequence.currval)" but this is not what I want.
> I only want to have the current value.
>
> Many thanks for any help
>
> Greetings Klaus Kloos
Received on Wed Feb 28 2001 - 00:40:04 CET

Original text of this message