A good reference for Oracle PL/SQL

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 f开发者_如何学Pythonor the PL/SQL language.

I am looking for references for the following:

• Variable
• Loops
• Cursor
• Packages
• Trigger
• Stored Procedures
• Temporary Tables

Thanks so much.

---

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.

---

One additional observation. You include temporary tables in a list of PL/SQL features. This is because you are used to the T-SQL way of doing things. In Oracle things are handled differently.

In Oracle we have global temporary tables. These are permanent database objects, like regular tables, but they are defined so that the data is held temporarily - either for the duration of a transaction or a session. The data in a global temporary table is only queryable by the session which populates it.

The point being that temporary tables are discussed in the SQL Reference, not the PL/SQL manual.

---

This reference is really good.

---

In addition to PL/SQL documentation that others have mentioned, the Oracle Database Concepts Guide is a good reference for finding out how Oracle works, including an overview of package, triggers, tables etc. I have posted a link to the 11.2 version, but you can find the docs for older versions here.

---

I've always found Tech on the Net to be good quick reference

---

Java2s has a good reference tutorial.

Here is the Oracle section: http://www.java2s.com/Book/Oracle/CatalogOracle.htm

Here is the Oracle PL/SQL reference catalog, easy to navigate: http://www.java2s.com/Code/Oracle/CatalogOracle.htm

Here is the Oracle PL/SQL tutorial section: http://www.java2s.com/Tutorial/Oracle/CatalogOracle.htm

I have the OReilly Book but won't post where I got that link along with Oracle Student workbook which is on Scribd.

And along with the Oracle references and tahiti oracle, this site was a good tutorial site for beginners. http://www.tutorialspoint.com/plsql/index.htm

---

Adding points to accepted answer:

• 1)Concepts for Database Developers
• 2) Temporary tables in stored procedure from AskTom Sample code snippet from AskTom open ref_cursor for select * from ( query you used to put into temp_1 ), ( query you used to put into temp_2 ) where join_conditions

in your procedure. You'll find that Oracle is much better at complex queries involving dozens (yes more then 16) tables -- without any issues whatsoever.