Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to say one of a group of columns is required?
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