Method Design Concepts

It is clear that moving procedures out of the application programs and into the database engine is a significant benefit of Oracle8's object-relational methodology. Not only does this provide a more secure repository for the code, but it encourages the concept of code reuse. If you combine these aspects with the ability to represent aggregate objects, then you have an extremely robust framework for dealing with complex real world application designs. From a pragmatic point of view, the following reasons are at the heart of any complete method design effort:

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.