Re: nextval

From: <steveee_ca_at_my-deja.com>
Date: Thu, 21 Dec 2000 12:53:51 GMT
Message-ID: <91sugu$o3$1@nnrp1.deja.com>

Hi,

Just to supplement what the other poster said, here's some simple syntax to show the point:

SQL> CREATE SEQUENCE P_ID; Sequence created.

SQL> INSERT INTO TEST
2 VALUES(P_ID.NEXTVAL); 1 row created.

SQL> As was said, you can specify a number of options in the CREATE SEQUENCE command..in it's basic form (as I've used above) it will start with the number 1 and increment by 1..
Hope this helps,

Steve

In article <977395547.302633_at_gate01.vertis.nl>, "MK" <kampherbeekm_at_netvisit.nl> wrote:
> 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.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 06:53:51 CST