Re: Cascade update

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/04/25
Message-ID: <3360c055.3306624@newshost>#1/1

On Thu, 24 Apr 1997 10:17:24 GMT, ee-ket.tang_at_dbsp.stems.com (ECatz) wrote:

>Hi!
>
>I know that Oracle allows cascade delete, but what about cascade
>update ?
>
>

Not directly. You can do it with triggers. Many will tell you to design your system so this is not an issue in the first place (self included). In the event you already have a system and need such a facility, drop by http://govt.us.oracle.com/ and check out the downloadable utilities. One of them is a package that automates the writing of the triggers needed to do update cascade (while declaritive RI is turned on)....

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 Fri Apr 25 1997 - 00:00:00 CDT