Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.oracle.misc > #889

Re: Foreign Keys

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!nntp.club.cc.cmu.edu!micro-heart-of-gold.mit.edu!bloom-beacon.mit.edu!bloom-beacon.mit.edu!panix!not-for-mail
From ruben safir <ruben@mrbrklyn.com>
Newsgroups comp.databases.oracle.misc
Subject Re: Foreign Keys
Date Fri, 12 Dec 2014 02:23:54 -0500
Organization PANIX Public Access Internet and UNIX, NYC
Lines 23
Message-ID <m6e564$kvh$1@reader1.panix.com> (permalink)
References <m4vm6i$hja$2@reader1.panix.com> <701d15b8-5f48-41d8-bc58-99a05b162f27@googlegroups.com>
NNTP-Posting-Host 96.57.23.82
Mime-Version 1.0
Content-Type text/plain; charset=windows-1252
Content-Transfer-Encoding 7bit
X-Trace reader1.panix.com 1418369028 21489 96.57.23.82 (12 Dec 2014 07:23:48 GMT)
X-Complaints-To abuse@panix.com
NNTP-Posting-Date Fri, 12 Dec 2014 07:23:48 +0000 (UTC)
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0
In-Reply-To <701d15b8-5f48-41d8-bc58-99a05b162f27@googlegroups.com>
Xref csiph.com comp.databases.oracle.misc:889

Show key headers only | View raw


> 
> SQL>
> SQL> ALTER TABLE WORKS_ON ADD CONSTRAINT workson_essn FOREIGN KEY (ESSN)
>   2  REFERENCES EMPLOYEE (SSN);
> 
> Table altered.
> 
> SQL>
> 
> My original assessment still stands -- there is data in the child table that isn't matched in the parent.
> 
> 
> David Fitzjarrell
> 


Thank You David

I appreciate it.  I read other people doing and I think to myself, oh
I'm not that stupid...

Ruben

Back to comp.databases.oracle.misc | Previous | NextPrevious in thread | Find similar


Thread

Foreign Keys ruben safir <dont@email.me> - 2014-11-24 16:25 +0000
  Re: Foreign Keys ddf <oratune@msn.com> - 2014-11-25 11:02 -0800
  Re: Foreign Keys ddf <oratune@msn.com> - 2014-12-01 05:46 -0800
    Re: Foreign Keys ruben safir <ruben@mrbrklyn.com> - 2014-12-12 02:23 -0500

csiph-web