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