SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating ORACLE sequence

515549Jul 3 2006 — edited Jul 3 2006

Hi,
I have a variable called ID. Now I want to insert values into a talble which has this ID field. I have intialised this variable to 1. I want to create an oracle sequence for this field(ID) so that I can use ID.nextval in my insert statement in order to populate this field.

How can I do it.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2006

Added on Jul 3 2006

5 comments

334 views