Re: Getting current sequence value

From: Mike Rose <mmrose_at_home.com>
Date: Mon, 29 Mar 1999 02:06:44 GMT
Message-ID: <UeBL2.17193$573.6977@news.rdc1.md.home.com>

I meant to use this example instead (Whoops)!

SQL/orc1> select Trips_SEQ.CurrVal From Dual;

CURRVAL

105501

SQL/orc1>

Mike Rose <mmrose_at_home.com> wrote in message news:tMAL2.17191$573.6997_at_news.rdc1.md.home.com...
> Why don't you use the following method, it works for me.
>

Erased ....
>
> Doug Cowles <dcowles_at_bigfoot.com> wrote in message
> news:36FECA76.A2A8D15A_at_bigfoot.com...
> > Is there any way to get the current value of a sequence number without
> > incrementing it? You can't use currval unless you define the sequence
> > for the session by calling nextval first. Is there any way around this?
> >
> > - Dc.
> >
>
Received on Sun Mar 28 1999 - 20:06:44 CST