Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sequence.nextval ?

Re: sequence.nextval ?

From: TimKArnold <timkarnold_at_aol.com>
Date: 14 Jan 2000 22:19:50 GMT
Message-ID: <20000114171950.02549.00000423@ng-ck1.aol.com>


What is the name of your sequence?
If have not created a sequence via
'create sequence 'seqname'.....

then it will never work.

So, first create sequence.

create sequence myseq.

Then
insert into table (dupcheckid) values
(myseq.nextval).

HTH,
Tim Received on Fri Jan 14 2000 - 16:19:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US