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: Jonathan A. Zdziarski <jonz_at_netrail.net>
Date: 2000/05/22
Message-ID: <1HaW4.19140$g41.1322940@news-west.usenetserver.com>#1/1

A check constraint can't go outside of its' column...you'll need a trigger.

"Andy Hardy" <aph_at_ahardy.demon.co.uk> wrote in message news:N32hvOAGJGJ5EwXR_at_ahardy.demon.co.uk...
> 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'm using Designer/2000 rel 2.1.1 onto an Oracle 7.3.4 database (later
> moving to 8.1.6 database).
>
> 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