Oracle Database Discussions

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!

Alternate Key Constraint

user12002352May 27 2010 — edited May 27 2010

Hi All
I have an existing application that is running 11g. I would prefer not to change the table structure; I understand it is not modeled correctly. I’m looking for an elegant solution for creating either a unique index or table constraint.

I have the following sample table
PK Name Alias
1 AAAA BBBB
2 BBBB
3 CCCC CCCC

I’m looking for a way to prevent record 2 from being inserted however record 3 is valid?

This post has been answered by Tubby on May 27 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2010

Added on May 27 2010

#general-database-discussions

5 comments

1,764 views