Re: Propagating parent key change to child table

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 12 Dec 1998 16:22:04 GMT
Message-ID: <367497e5.2605146@192.86.155.100>

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

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Dec 12 1998 - 10:22:04 CST