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: Maciej Zoltowski <mzoltowski_at_eragsm.com.pl>
Date: 2000/05/19
Message-ID: <3924D349.A768A808@eragsm.com.pl>#1/1

Andy Hardy wrote:
>
> Hi,
>
> I have a table with three columns - one or more of which is required.
>
> E.G.
>
> MY_KEY
> MY_LOOKUP1
> MY_LOOKUP2
> MY_LOOKUP3
>
> where at least one of the MY_LOOKUPs is required.
>
> Is there a check constraint for this?

I think that you have to write your own trigger to check this.

Regards
Maciek Received on Fri May 19 2000 - 00:00:00 CDT

Original text of this message

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