Re: Howto put a sequence in a variable.

select sequence.nextval
into l_id
from dual;

Dirk Joosen wrote:
>
> Hello
>
> Is it possible to get the value of a sequence and to write these to
> an variable. I could be something like
> l_id NUMBER;
> l_id : = SEQUENCE.NEXTVAL;
>
> This is not allowd but is there a possibility to make this work???
> Regards and thanks Dirk

Received on Wed Nov 17 1999 - 11:13:35 CST