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!

relating a sequence to a table

276609May 30 2002

hi there
i have a table "Employee" for which I have an index column emp_no (Primary Key).
i want to write a sequence for this column, such that it starts at 1 and gets incremented by 1 everytime I insert a row in "Employee"

Any help will be great.

Mahesh.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2002

Added on May 30 2002

5 comments

294 views