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


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

Re: Foreign Keys

From ruben safir <ruben@mrbrklyn.com>
Newsgroups comp.databases.oracle.misc
Subject Re: Foreign Keys
Date 2014-12-12 02:23 -0500
Organization PANIX Public Access Internet and UNIX, NYC
Message-ID <m6e564$kvh$1@reader1.panix.com> (permalink)
References <m4vm6i$hja$2@reader1.panix.com> <701d15b8-5f48-41d8-bc58-99a05b162f27@googlegroups.com>

Show all headers | 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