Programming Books C Java PHP Python Learn more Browse Programming Books
Oracle PL/SQL Language Pocket Reference (Pocket Reference and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Start reading Oracle PL/SQL Language Pocket Reference on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) [Paperback]

by Steven Feuerstein, Bill Pribyl, Chip Dawes
4.1 out of 5 stars  See all reviews (14 customer reviews)

List Price: $14.99
Price: $12.83 & FREE Shipping on orders over $35. Details
You Save: $2.16 (14%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Gift-wrap available.
Want it Monday, April 28? Choose Two-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $8.69  
Paperback $12.83  
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Book Description

October 30, 2007 0596514042 978-0596514044 Fourth Edition

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.

This concise guide boils down the most vital PL/SQL information into an accessible summary of:

  • Fundamental language elements (e.g., block structure, datatypes, declarations)

  • Statements for program control, cursor management, and exception handling

  • Records, procedures, functions, triggers, and packages

  • Calling PL/SQL functions in SQL

  • Compilation options, object-oriented features, collections, and Java integration
The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages.

When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Frequently Bought Together

Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) + SQL Pocket Guide
Price for both: $25.16

Buy the selected items together
  • SQL Pocket Guide $12.33

Editorial Reviews

Book Description

A Guide to Oracle's PL/SQL Language Fundamentals

About the Author

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Bill Pribyl is the primary author of "Learning Oracle PL/SQL" and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at

Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. He is currently a consultant with D&D Technologies, a Chicago consultancy. He enjoys working with, lecturing on, and writing about Oracle database administration, client server application development, and Unix system administration. Chip is an Oracle Certified Professional and earned computer science and aerospace engineering degrees from St. Louis University.

Product Details

  • Series: Pocket Reference (O'Reilly)
  • Paperback: 180 pages
  • Publisher: O'Reilly Media; Fourth Edition edition (October 30, 2007)
  • Language: English
  • ISBN-10: 0596514042
  • ISBN-13: 978-0596514044
  • Product Dimensions: 7 x 4.5 x 0.4 inches
  • Shipping Weight: 4 ounces (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #275,100 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.1 out of 5 stars
4.1 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
22 of 24 people found the following review helpful
3.0 out of 5 stars Only "OK" May 18, 2000
I've worked with Oracle for quite a while, and I've tinkered with PL/SQL, triggers, etc. on and off during the time that I used Oracle. Recently, I needed to write a really simple PL/SQL program to assist in doing a backfill. I bought this book expecting to pluck out details quickly for writing this program. Unfortunately, there was no index, and the table of contents was a little too high-level to help you find specific information. Finally, once you locate an appropriate section, the text is terse and the examples are quite basic.
I concede that I probably should've bought "Oracle PL/SQL Language" the book for which this is a reference for my particular need. Just beware, however, that this book is solely a reference, and is hard to use unless you already know PL/SQL.
Comment | 
Was this review helpful to you?
11 of 11 people found the following review helpful
5.0 out of 5 stars Great pocket reference, 2nd edition WITH INDEX now April 3, 2003
This small booklet "ORACLE PL/SQL Language Pocket Reference" in this new 2nd edition is exactly what you need as PL/SQL (PL/SQL is the ORACLE procedural language extension of SQL) programmer (and is even more important for casual PL/SQL programmer).
"ORACLE PL/SQL Language Pocket Reference" assumes that you are running at least ORACLE 8i and it covers ORACLE 9i as well (ORACLE 9i features are marked as such).
The content and coverage of the book is very good from my perspective. Even the more exotic features that I just can't remember, like e.g. the AUTHID stuff for PL/SQL procedures, are covered in this book. Even if you do not remember the exact keyword to look something up in the index, the book is still small enough to brose over every page in a couple of minutes to find your solution. All of the ORACLE 9i features (that I know of) are explained like e.g. "bulk binds" (cool PL/SQL performance feature).
The language and the new index are very good.
Even though this is a relatively small book, there are examples for almost every topic covered (although not big ones).
This is NOT the right book to learn PL/SQL and it will not teach you any SQL. If you want to learn PL/SQL, I recommend the other books (by the same authors) from O'Reilly that are all VERY good.
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
3.0 out of 5 stars Handy but could be easier to access topics June 4, 1999
By A Customer
Format:Paperback|Verified Purchase
There is no index and only a scanty table of contents. You are forced to go to the area and browse for information. It is a short book, and scanning works, but an index would be more efficient.
Comment | 
Was this review helpful to you?
7 of 7 people found the following review helpful
4.0 out of 5 stars All it needs is an Index! March 27, 2000
An index would make this pocket reference 5 stars. The TOC - (Table of Contents) is helpful but an Index would be better in addition to the TOC.
Comment | 
Was this review helpful to you?
5 of 5 people found the following review helpful
5.0 out of 5 stars Boris Belous Excellent partner for quick lookup. May 17, 1999
By A Customer
Concise, precise and to the point. While not a complete reference, it servers its purpose well: quick lookup of on the fly syntax questions. Tiny, but the author found enough space to squeeze in an actual example of most major constructs.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Nice, compact, but it really needs an index! April 2, 2002
A good sidekick for when you have a mental lapse, unfortunately they seem to have forgot to print the index.
This book will not replace any other PL/SQL book you have (or should have) in your tech library, but is great to have around on your desk instead of the usual 4,000 pages tomes.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent reference for PL/SQL programming December 6, 2007
Oracle PL/SQL Language Pocket Reference
Steven Feuerstein
O'Reilly - 4th Edition

This book covers the most common topics in PL/SQL in a compact format. The format is "pocket reference" which is considerably smaller than a standard book. The information is still complete. It appears the publisher accomplished this by eliminating blank pages between chapters, avoiding the use of large type for chapter headings, and beginning the next chapter a few lines after the previous. This format is convenient for people who need to use the reference often.

The items covered are numerous and relevant making the book a good value. The reference does not cover the SQL language itself outside the context of PL/SQL programming. It also does not go into extreme detail on how Oracle is working behind the scenes. It focuses on how to perform the task at hand then moves onto the next topic. This is good for those just looking for an answer but would not provide the detail to someone studying the inner workings of Oracle itself.

Some of the items covered that I found most useful were:

Exception handling
Transaction management
Syntax of various loops and the case statement
Bulk operations
Syntax of triggers
Differences between 9i and 10g

Overall this is an inexpensive, quality reference for those who program PL/SQL.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Great little reference
Answers 90% of the questions I used to go to my full size book to find.
However, I still consider it a supplement to the real book NOT a replacement.
Published 9 months ago by R. Cline
4.0 out of 5 stars Simple but useful
Gorgeous! I would like to recommand this book to you. It can save your time for the coding details and make you qualified for the PL/SQL task.
Published 12 months ago by Silvia Tsai
5.0 out of 5 stars really useful
a quick reference when writing a procedure and package,
most useful for people who first time use oracle or not familiar with some language features
Published 14 months ago by barry chen
5.0 out of 5 stars life saver!
this book has been very useful sometimes. It has a lot of details for a pocket reference. definitely recommend it.
Published 16 months ago by tony s
4.0 out of 5 stars Good But Tough To Condense
The 'Oracle PL/SQL Language Pocket Reference' is a good pocket reference for Oracle 11g but I feel that this subject matter is tough to condense in size. Read more
Published on July 3, 2008 by Dan McKinnon
5.0 out of 5 stars New sections on Oracle's built-in functions rounds out the update.
Steven Feuerstein, Bill Pribyl and Chip Dawes' ORACLE PL/SQL LANGUAGE POCKET REFERENCE provides the fourth edition of a popular pocket guide which will serve as a quick reference... Read more
Published on February 6, 2008 by Midwest Book Review
1.0 out of 5 stars anO'REILLY flop
Where's the index?? A REFERENCE is something you pick up to find a particular needed peice of information. Read more
Published on August 28, 2002 by K. Ambrose
Search Customer Reviews
Only search this product's reviews

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category