-
ok, I have an order form and need to add an order but now need a sequence number. i know the code goes something like
create sequence order
start with 1000 increment by 1;
How do i get this to increment by one? Or is that code wrong?
Thanks for any help!!!
-
Try
create sequence blablabla
increment by 1
start with startnumber;
Good Luck.
David Knight
OCP DBA 8i, 9i, 10g
-
Every time you select sequence.nextval, the sequence is automatically incremented by the database.
-
thanks
you guys are awesome. and fast!!!!
Digiaks "future Oracle DB adm"
-
sequence
okay, i created the sequence. buuuuttt (i am stupid). how do you use it??
INSERT into table1
value(sequence?)
thanks
-
Re: sequence
Originally posted by digiaks
okay, i created the sequence. buuuuttt (i am stupid). how do you use it??
INSERT into table1
value(sequence?)
thanks
INSERT into table1
value(sequence_name.nextval);
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|