Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> existence question
Greetings.
Can someone help me out here?
I have a table. with a unique index across five columns (c1, c2, c3, c4, c5.
I was trying to figure out if there was a way to form an sql where clause that would tell me if a certain business rule would be violated.
The rule says, for a given (c1 c2), if you have any rows that have c4 and c5 null, then you can't have any other rows for that (c1 c2) which have a not null c4 or a not null c5.
I'm a bit out of practice.
Thanks
Jeff
Jeff Kish
Received on Wed Jul 21 2004 - 09:31:02 CDT