I recently put some more PL/SQL new features articles live.
I’ve also posted a top-level new features article.
This contains a number smaller features as well as links to other articles on the site that discuss some of the new features in greater depth.
I’ve got a couple of PL/SQL books I’ve got to read and review, but I’ve been holding back because I wanted to get my take on this subject written before I was influenced by others. I guess I don’t have that excuse any more.
I’ve just released an article covering the Miscellaneous New Features section of the OCP upgrade exam. It contains a rather random assortment of stuff including:
- Online Table Redefinition Enhancements
- Enhanced Finer Grained Dependency Management
- DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
- Invisible Indexes
- Query Result Cache
- Adaptive Cursor Sharing
- Temporary Tablespace Enhancements
I was toying with the idea of putting each section out as separate articles, but they’re all pretty small soundbites, so I thought I would be better to stick with grouping in the OCP syllabus.
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.
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.