A good reference for Oracle PL/SQL

Question

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.

Thanks to everyone for their time and their links – David Waters Jan 12 '10 at 09:54 — David Waters, Jan 12 '10 at 09:54

score 20 · Accepted Answer · edited Apr 05 '16 at 04:59

20

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.

edited Apr 05 '16 at 04:59

user272735

10,473
9
65
96

answered Jan 11 '10 at 13:04

APC

144,005
19
170
281

1

That's a good book, as a bonus if you're going to purchase at Oreilly.com, using coupon code LREL40 gives you a 40% – Sathyajith Bhat Jan 11 '10 at 14:10
2

Feuerstein is definitely the guru when it comes to PL/SQL – Doug Porter Jan 11 '10 at 14:14
1

I learned PL/SQL out of that book. Well worth the investment. – orbfish Dec 13 '10 at 16:34

score 7 · Answer 2 · answered Jan 11 '10 at 13:16

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.

score 2 · Answer 3 · answered Jan 11 '10 at 12:54

2

This reference is really good.

answered Jan 11 '10 at 12:54

Klaus Byskov Pedersen

117,245
29
183
222

Or for latest version (11.2): http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/toc.htm – Tony Andrews Jan 11 '10 at 13:40

score 2 · Answer 4 · answered Jan 11 '10 at 13:48

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.

score 2 · Answer 5 · answered Jan 12 '10 at 04:14

2

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

answered Jan 12 '10 at 04:14

barker

31
3

Nicly indexed quick reference, not very in depth though. – David Waters Jan 12 '10 at 09:53

score 0 · Answer 6 · answered Feb 02 '13 at 22:51

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

score 0 · Answer 7 · answered Sep 08 '16 at 13:10

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.

A good reference for Oracle PL/SQL

7 Answers7

Linked

Related