Re: Check constraint question
Andy Hassall wrote:
> On Thu, 24 Aug 2006 23:08:09 +0200, Ruben Schoenefeld
> <Ruben.Schoenefeld@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 |