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!

XOR 3 columns, one has to be set

687889Feb 26 2009 — edited Feb 26 2009
Hey there,

I have to check via constraints if one of three references is set.
For example: I have three columns, id1, id2 and id3.
One of this 3 columns have to be filled with an id. The other two columns have to be null (like xor).
Any idea how I can check this via a check constraint?

Greets,
John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2009
Added on Feb 26 2009
3 comments
992 views