oracle foreign-key question

Jonathan Ellis jonathan at carnageblender.com
Tue Aug 22 19:54:55 MDT 2006


On Tue, 22 Aug 2006 19:34:46 -0600, "Michael A. Cleverly"
<michael at cleverly.com> said:
> On 8/22/06, Jonathan Ellis <jonathan at carnageblender.com> wrote:
> 
> > A simpler CHECK would be (user_id is null != visitor_id is null).
> 
> That isn't valid Oracle syntax (at least in 9i).

Ah.  It works in other databases.

-Jonathan
-- 
C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay




More information about the PLUG mailing list