A good reference for Oracle PL/SQL

oracle, plsql, sql

Solution

As Klaus says the online documentation is pretty good. Start with the 2-Day Application Developer's Guide. If you're using 11gR2, you'll want to read the most recent version of the PL/SQL Language Reference. Newer Oracle releases have updated versions of the documents.

But if you want to buy a book, then Steven Feuerstein's Oracle PL/SQL Programming is the one.

Problem

What are the best references for Oracle PL/SQL? I have an excellent knowlege of SQL-92 and of MS-SQL extensions, but now I'm working with Oracle and I'm struggling to find good references for the PL/SQL language. I am looking for references for the following: - Variable - Loops - Cursor - Packages - Trigger - Stored Procedures - Temporary Tables Thanks so much.

Original source