Re: Nextval

Test Reply, Please ignore

"Biss Is Ignorance" <bliss_is_ignorance_at_hotmail.com> wrote in message news:3a448735.0_at_news.tm.net.my...
> 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 Mon Mar 12 2001 - 19:38:30 CET