Xref: alice comp.databases.oracle.misc:23719
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!su-news-hub1.bbnplanet.com!news.gtei.net!news.sprintisp.com!sprintisp!not-for-mail
From: david.swanson@sprintranet.com (Power User)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Propagating parent key change to child table
Date: Sat, 12 Dec 1998 19:30:30 GMT
Lines: 29
Message-ID: <3672c441.714890@nntp.sprintisp.com>
References: <367218CB.2AD11A19@2xtreme.net> <367497e5.2605146@192.86.155.100>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.451

I think the URL should be:

http://govt.oracle.com/govt/owassi/docs/utility/update_cascade.html

On Sat, 12 Dec 1998 16:22:04 GMT, tkyte@us.oracle.com (Thomas Kyte)
wrote:

>A copy of this was sent to PMG <pete_g@2xtreme.net>
>(if that email address didn't require changing)
>On Sat, 12 Dec 1998 07:18:31 GMT, you wrote:
>
>>What is the best way to set up the realtionship between parent table and
>>child table so that when one changes the parent table's PK the change is
>>propagated to automatically change the child table's FK?
>>
>
>this is called an update cascade.  One way of implementing this is available at
>http://govt/govt/owassi/docs/utility/update_cascade.html
>
>>TIA
>>
>>Pete
>
> 
>Thomas Kyte
>tkyte@us.oracle.com
>Oracle Service Industries
>Reston, VA   USA