View Single Post

   
  #7 (permalink)  
Old 04-08-2008, 11:13 AM
Ed Prochak
 
Posts: n/a
Default 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

Reply With Quote