Search code examples
oracle-databaseplsqlagileintentional-programming

Recommendation for a book on "expressive" PL/SQL?

Let me be clear - I have more than enough "references" and "for beginners" books.

What I want is something like "Exceptional PL/SQL" or "Agile PL/SQL" or "PL/SQL Design Patterns" or even just "PL/SQL For Developers Who Want To Write Pretty Code".

Does such a thing exist?

(I'm a C++/Ruby/etc. developer. I've been thrown into an Oracle project. The language makes me feel like my hands are tied behind my back and there's a burlap bag over my head. It's bringing back bad memories of DBase and Clipper...)

Solution

  • I found this book useful:

    Oracle PL/SQL Best Practices

    And there are a bunch of other books by O'Reilly that might be useful to you here.

    Also, if I could recommend something to read, I would suggest an Oracle performance book. So many avoidable performance issues are often introduced by people new to PL/SQL.