Re: Nextval

Hi,

To use nextval you first need to create a sequence

SQL> Create Sequence Id_Seq;

Now suppose the table into which you want to insert values is EMP and column is ID give the command

SQL> Insert Into EMP (ID) Values (Id_Seq.NextVal);

In case you do not want to use a sequence you can also try the following command

SQL> Insert Into EMP (ID) Values ((Select Max (ID) + 1 From Emp));

Hope this helps

Regards,
Aparna

"MK" <kampherbeekm_at_netvisit.nl> wrote in message news:977395363.377972_at_gate01.vertis.nl...
> Hi,
>
> I got a field ID, when I submit a form the ID must get a next value. How
 can
> I do that?
> VALUES
> (p_ID.nextval
>
> That doesn't work. I get the error Identifier 'P.ID.NEXTVAL' must be
> declared.
>
>
>
>
Received on Sat Dec 23 2000 - 11:34:42 CET