|
|
| |
 |
|
A
Generic Cascade Update Procedure
Oracle Tips by Mike Ault |
Summary
Utilizing the procedures and trigger described
in this article a Remote DBA can enforce a cascade update against any set
of master-dependent tables without the performance hit of searching
the data dictionary for the relationship definitions.
SEE CODE DEPOT FOR FULL SCRIPTS
 |
If you like
Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference , with over 900
pages of BC's favorite tuning tips & scripts.
You
can buy it directly from the publisher and save 30%, and get
instant access to the code depot of Oracle tuning scripts. |
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
