Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sequence.nextval ?
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
![]() |
![]() |