Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign Key in ORacle 7.3

Re: Foreign Key in ORacle 7.3

From: Joseph S. Testa <jtesta_at_scioto.net>
Date: 1997/11/19
Message-ID: <34739A6B.106A4AB1@scioto.net>#1/1

Wai B Kam wrote:

> I create a foreign key with ON DELETE CASCADE option. When I delete the parent key, the child key
> does get deleted. But if I try to update the parent key, error comes up saying child key found.
> I thought Oracle will handle that also?? Please Help me. Thank You

update cascade does not exist for 7.3, you can program it if you want.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop column script
ICQ UIN:  2832230(&oracle, home).
Received on Wed Nov 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US