Skip to Main Content
Forums

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!

Addding a primary key to an existing table

CometAug 13 2009 — edited Apr 3 2018
A developer on my team created a table named Resources_T in Oracle 10g and did not add a primary key. I want to add a primary key name Resource_ID. What are some ways to add a primary key and automatically generate values for the pre-existing rows and rows to be added later.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 13 2009
#sql, #table
6 comments
4,429 views