Know some Oracle PL/SQL? Want to become far more fluent with the language, quick confident that you can take on any project that comes at you? Check out Oracle PL/SQL Programming Developer's Workbook. Steven Feuerstein wrote this book with the goal of actively engaging you, provoking a response, and getting you to solve problems you might not otherwise have dared to try. He succeeds.
The organization of the book is excellent. Problems in the first half, solutions in the second half so you don't "stumble across" Feuerstein's answers before you've had a chance to come up with your own. Within each chapter, exercises are organized by level of experience, so you can go straight to "beginner," "intermediate," or "expert" problems and also get an objective idea of where you really stand.
Feuerstein opens with language fundamentals: declaring variables and naming elements; loops; conditional and sequential control; and records. Next, he presents challenges associated with data structures: index-by tables, nested tables, variable arrays, and object technology. In Part III, Feuerstein helps you deepen your understanding of database interaction: cursors, DML, transaction management, cursor variables, and native dynamic SQL.
The book includes extensive coverage of program construction, Oracle PL/SQL's built-in functionality; and more including a chapter on Java stored procedures, one on tuning and one on web development.
Whatever other PL/SQL book youmayalready own, this one will help you deepen your understanding as never before. With this book, you can really make PL/SQL yours.