Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to say one of a group of columns is required?

Re: How to say one of a group of columns is required?

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 2000/05/22
Message-ID: <ufDp1nBcwOK5EwoD@ahardy.demon.co.uk>#1/1

In article <8gaojc$in7_at_grant.grant.UUCP>, Alexander I. Doroshko <aid_at_grant.kharkov.ua> writes
>>
>> It looks like I need the trigger!
>>
>> Andy
>Why don't You use a constraint
>
>CHECK(my_key IS NOT NULL OR my_lookup1 IS NOT NULL OR ...)?

You're right - that looks like the easiest answer.

Thanks,

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================
Received on Mon May 22 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US