Re: Is it possible to update Primary Key Columns ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/04/09
Message-ID: <334c864f.81932652@newshost>#1/1

On 9 Apr 1997 03:48:42 GMT, ceham_at_w3eax.umd.edu (Maurice De Vidts NE3S) wrote:

>Hi,
>
>
>I would like to know how I can 'update' a primary key value
>on a Parent table which has a populated child table ?
>
>is there a way to 'cascade' the update to all the child tables ?
>

You can check out the Update Cascade Package available on http://govt.us.oracle.com/ under downloadable utilities (look in the 'quick picks' section on the home page).

It uses triggers to capture and propagate updates from a parent to all child tables even while declaritive RI is turned on (example of how to avoid mutating tables).....

>Thanks,
>
>Maurice
>ceham_at_w3eax.umd.edu

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

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

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Apr 09 1997 - 00:00:00 CDT