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!

Urgent Please !Enforcing Unique Key Using a DataBase Trigger

299346Mar 14 2003 — edited Mar 14 2003

Hello,

IS there a way to force the Unique Key Constraint using the Database trigger instead of creating a Unique Key. Because My Requirement is such that I have to Enforce Unqueness Based on Certain Condition.

For Example I have a Part_Numbers Table which has the following fields..
id (Primary key)
Part_type
Part_number
part_number_owner

in the above table For certain PArt_number_owners the Part_number can be Duplicate, but not for all.

Do you think this can be done in a Trigger?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2003

Added on Mar 14 2003

4 comments

359 views