I finished “Oracle PL/SQL Performance Tuning Tips & Techniques” by Michael Rosenblum and Paul Dorsey today.
I recommend it as a lesson, a reference, and an inspiration for things to try.
Steven Feuerstein still gets the nod as the “go to” for first learning how to use pl/sql; but this book has great examples for learning how to use it better.
It’s quite readable, definitely one of the best out of Oracle Press I’ve seen in a while.
The examples cover 11g and some 12c as well when warranted. The code snippet construction is particularly good. They are not only complete and functional but don’t come off as completely arbitrary. They are modeled after real world tasks, making it much easier to relate to them.