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 | Next — Previous 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