Generic Cascade Update Procedure
Oracle Tips by Mike Ault
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.
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.