Re: Howto put a sequence in a variable.

select sequence.nextval
into l_id
from dual;

that it.

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 - 10:43:33 CST