BUY THIS BOOK
Add to Cart

Print Book $14.99


Add to Cart

Print+PDF $19.49

Add to Cart

PDF $11.99

Safari Books Online

What is this?

Add to UK Cart

Print Book £8.99

What is this?

Looking to Reprint or License this content?

Envelope Tell a friend
Oracle PL/SQL Language Pocket Reference, Fourth Edition

By Steven Feuerstein, Bill Pribyl, Chip Dawes
October 2007
Pages: 178
Series: Pocket References
ISBN 10: 0-596-51404-2 | ISBN 13: 9780596514044
starstarstarstarstar (Average of 1 Customer Reviews)

Buy 2 Get 1 Free Free ShippingGuarantee

Description

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. 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.
Full Description

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.

Featured customer reviews

Write a Review


Excellent reference on PL/SQL programming and syntax,  December 06 2007
Rating: StarStarStarStarStar
Submitted by jdruin   [Respond | View]

Oracle PL/SQL Language Pocket Reference
Steven Feuerstein
O’Reilly – 4th Edition
http://www.oreilly.com/catalog/9780596514044/index.html

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:

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

Overall this is an inexpensive, quality reference for those who program PL/SQL.

Read all reviews

Media reviews
"[Consumers] will find the fine 'pocket references' produced by O'Reilly to be compact and affordable."
-- James Cox, The Computer Shelf: Midwest Book Review



Read all reviews

See larger cover

Got a Question?






Favicon Service and support by Satisfaction