In part one we say about Mutating Trigger and how PRAGMA AUTONOMOUS_TRANSACTION helped to resolve the same. Remember PRAGMA AUTONOMOUS_TRANSACTION is just an work around to perform. Though Oracle allows…
Oracle 11g has introduced Compound Triggers, before we go deep in to this we need to first understand what is the need for it. Will this help me to resolve...Read More
No posts were found.
The word "Tuning" should be in discussion right at the initial stage of your design and not just after shipping you code to production. In most of the environments have...Read More