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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Propagating parent key change to child table

Re: Propagating parent key change to child table

From: Power User <david.swanson_at_sprintranet.com>
Date: Sat, 12 Dec 1998 19:30:30 GMT
Message-ID: <3672c441.714890@nntp.sprintisp.com>


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_at_us.oracle.com (Thomas Kyte) wrote:

>A copy of this was sent to PMG <pete_g_at_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_at_us.oracle.com
>Oracle Service Industries
>Reston, VA USA
Received on Sat Dec 12 1998 - 13:30:30 CST

Original text of this message

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