On the surface, the changes to PL/SQL look rather minor, but there is some seriously cool stuff in there. I originally intended to write a single article, but some sections got too big so I thought it was worth sectioning them out into separate articles.
- PL/SQL New Features and Enhancements in Oracle Database 11g Release 1
- Cross-Session PL/SQL Function Result Cache
- PL/SQL Hierarchical Profiler
- Trigger Enhancements in Oracle Database 11g Release 1
As usual, I’ve tried to keep the explanations brief and include cut & paste examples.
There are a couple more things I might add, but I’m not sure if they are too niche. I’ll see what I think over the next couple of days.