Re: Check constraint question

From: Ed Prochak <edprochak_at_gmail.com>
Date: 25 Aug 2006 09:05:34 -0700
Message-ID: <1156521934.609272.89180@h48g2000cwc.googlegroups.com>

Andy Hassall wrote:
> On Thu, 24 Aug 2006 23:08:09 +0200, Ruben Schoenefeld
> <Ruben.Schoenefeld_at_uni-oldenburg.de> wrote:
>

[]

> >>Instead of using an "or" and two "and"s, is there an "xor" that I can
> >>use? Like:
> >>constraint ck1_signalhead check (mastarm_id xor structure_id)
>
> Curiously, no, Oracle haven't implemented an xor operator; an omission on
> their part which you have worked around correctly.

Not an ommision by Oracle. There is no such operator in the SQL standard.

It might be a nice enhancement though.

Ed Received on Fri Aug 25 2006 - 11:05:34 CDT