Re: Does 'Nextval" work in Oracle 7?

Sure, try select mysequence.nextval from dual (returns next sequence number)

           or select mysequence.currval (returns current sequence number)

zhao wrote:

> Hi All,
>
> I am not sure whether the "mysequence.Nextval" select statement work in
> Orale 7 after I created a sequence called "mysequence".
>
> Thanks
>
> Andy
  Received on Tue Dec 11 2001 - 16:43:52 CST