ERPMVP.com

	Shop

Oracle PL/SQL Programming, 4th Edition

SKU:

Availability: Usually ships in 1 business days

If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.
Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall
Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

List Price:	$64.95
Our Price:	$40.92 & this item ships for FREE with Super Saver Shipping.
You Save:	$24.03 (37%)

Note: Item may be sold and shipped by another company. Learn more.

Product Promotions

This title is eligible for Amazon Fall Textbook promotions. Get unlimited free Two-Day Shipping for three months with a free trial of Amazon Prime. Add $100 worth of eligible textbooks to your cart to qualify. Sign up at checkout. New members only. Here's how (restrictions apply)

Product Details

Author:	Steven Feuerstein
Paperback:	1198 pages
Publisher:	O'Reilly Media, Inc.
Publication Date:	August 22, 2005
ISBN:	0596009771
Package Length:	9.1 inches
Package Width:	6.9 inches
Package Height:	1.9 inches
Package Weight:	3.3 pounds
Average Customer Rating:	based on 86 reviews

Customer Reviews

Average Customer Review: 4.0

Write an online review and share your thoughts with other customers.

2 of 3 found the following review helpful:

Impossibly long yet incomplete Apr 17, 2008
This book so incredibly long that it is impossible to use to actually learn PL/SQL. Each of its numerous long chapters is so focused on a small, isolated sub-topic of PL/SQL that it spends over 500 pages just to cover the basics of PL/SQL. At that point, 500 pages into the book it says, "by now you have mastered the basics of PL/SQL" and begins a series of long chapters on small, isolated advanced sub-topics.

Worst of all, the book does not cover or even mention the essential, crucially important "Windows Functions" added to the ISO SQL standard in 2003.

I recommend instead buying "Sql Cookbook" by Anthony Molinaro in preference to this book. The former is direct and to the point. The latter is so convoluted and stretched out that it's useless for a busy professional who does not have unlimited time to spend hundreds of hours reading a 1,100 page book. Granted that "Sql Cookbook" does not cover PL/SQL, but at least it teaches you something you can use on the job immediately.

MASSIVELY informative... yet surprisingly easy to read for beginners & intermediates Mar 11, 2008
I've worked with Oracle and PL/SQL on and off for ages. I never really took a dive into the details of anything until recently. I knew the basics of PL/SQL blocks, writing procedures/functions and some of the "advanced" column/data types and interactions with them(XML with XPath, for example).

Being a professional software engineer for some time now and working with Oracle regularly has lead me down a path of basic knowledge. This book took that knowledge and pushed the boundaries further than I could have imagined. Great detail, simple/concise/powerful examples and explanations coupled with the author's ability to write with humor make this a wonderful read from beginner to intermediate.

Advanced users/developers may find it useful merely as a reference, however. It is something that will surely be worn out as time goes on.

The PL/SQL Standard Nov 30, 2007
As with the three previous editions, all of which I own, this book sets the standard for PL/SQL texts. Crammed with information, it provides a thorough and insightful reference and always has a place on my desk.

If you program in PL/SQL, then you need this book. Oct 01, 2007
It is clear, concise, and as far as I can tell, correct. The writing is friendly, and the examples useful. I learned far more about PL/SQL from this book than from the Oracle documentation. I recently heard the author speak at a conference, and his good personality is reflected in the book.

The most famous PL/SQL author Sep 19, 2007
No doubt you must own this book if you start learning PL/SQL or if you want to improve your coding. Steven reveals many traps that may be in your code. It explains how to take advantage of multiple techniques like BULK COLLECT.

It may serve as a reference book too