Search
 Programming

Software Design, Testing & Engineering

Languages & Tools

BPEL

Application

 
 
 
 
 
 
 
 
 
 
 
Home

Programming

Software Design, Testing & Engineering

Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series)

Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series)
Email a friendEmailView larger imageZoom

Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series)

 
SKU:  

In Stock
Availability:   Usually ships in 1 business days
 
 

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.

  • Create, debug, and manage Oracle-driven PL/SQL programs
  • Use PL/SQL structures, delimiters, operators, variables, and statements
  • Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
  • Work with functions, procedures, packages, collections, and triggers
  • Define and deploy varray, nested table, and associative array data types
  • Handle external routines, object types, large objects, and secure files
  • Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
  • Call external procedures through Oracle Net Services and PL/SQL wrappers
  • Integrate internal and server-side Java class libraries using Oracle JVM
  • Develop robust Web applications using PL/SQL Gateway and Web Toolkit

 
List Price: $59.99
Our Price: $37.79 & this item ships for FREE with Super Saver Shipping.
You Save: $22.20 (37%)
 
 

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


Product Details
Author:Michael McLaughlin
Paperback:835 pages
Publisher:McGraw-Hill Osborne Media
Publication Date:March 21, 2008
Language:English
ISBN:0071494456
Package Length:9.06 inches
Package Width:7.32 inches
Package Height:1.89 inches
Package Weight:3.04 pounds
Average Customer Rating: based on 13 reviews

Customer Reviews
Average Customer Review:4.0
Write an online review and share your thoughts with other customers.

3 of 4 found the following review helpful:

2Need to find a better book.  Feb 08, 2010
This is probably one of the worst books you can find for Oracle 11g PL/SQL. With so many typos all over the book, Reading this is not going to be very pleasant. The author could have tried to save the reader's time by avoiding redundant information. For instance he explains about CLOB in few pages and when he comes to explain BLOB, it's just Copy paste CLOB explanation, Find the word 'CLOB' and replace with 'BLOB'. Though this book is not meant to help you pass the Oracle PL/SQL exam, I guess a good technical book should have exercises, but this one does not. The irony is this one of the very few books available for Oracle 11g PL/SQL programming.

1 of 2 found the following review helpful:

1Full Of Incomplete Information And Full Of Errors  Jan 20, 2010
This book is full of coding errors and incomplete descriptions of the tasks required to implement PL/SQL. I think the author assumes that the reader already knows a lot about PL/SQL. In addition, there are many code and text errors. I do not know the other people who gave this book such glowing reviews, but most of them must have some previous knowledge of PL/SQL and have learned to accept the fact that many publishing companies do not take the required steps to insure the accuracy of their texts. This is the first time I purchased a book from Oracle Press. And maybe the last.

1 of 4 found the following review helpful:

2Not very helpful for OCP preparation  Nov 11, 2009
I have been working with PL/SQL for several years and I am now preparing for an OCP exam. I find the style of McLaughlin's book not well suited for exam preparations. Some parts of the text are a bit confusing, occasionally he introduces terms without explaining them, on the other hand he presents the same definitions multiple times in every new section. Lot of important details are never mentioned while some rarely used features get a lot of attention. Also the examples are not all error free. I have put this book aside and use for my preparations the slightly dated "OCP Developer PL/SQL Program Units Exam Guide" from Steve O'Heran. This book is much better suited for an exam preparation. I will only look up the new features in McLaughlin's book.

2 of 2 found the following review helpful:

5GREAT book!!  Oct 30, 2009
This is the first technical/computing book that I have ever read cover to cover.
In fact I read this book cover to cover with multiple iterations of chapters that were difficult for me (e.g., Chapter 6 Functions and Procedures, Chapter 8 Large Objects, Chapter 13, External Procedures, Chapter 14 Object Types and the PHP/Java Primers in Appendices C and D, respectively).
I have been a PL/SQL Developer for over 6 years.
I thought I was doing pretty well but it turns out I was doing a limited number of things in my development experience over and over again. The ease with which I was writing functions and procedures, organizing the same in packages and utilizing a very few of the more advanced features like BULK COLLECT and BULK UPDATE was a deceptive set of convenient facts: Thanks to this book I now know how much I didn't know and I have a more than vague feeling that even now my ship is still relatively close to shore. There is much more the the "sea of PL/SQL", if you'll allow me that much of a poetic license!
I was particularly surprised to find out how little I knew about Oracle functions after having written so many over the years. Pipelined functions? I had never heard of them! Creation options? Eh...those either! I did not know you could used mixed notation to make a call to a procedure with multiple parameters.
The book has some typographical/copy and paste-type issues which threw me off in the beginning. It's likely not the book as much as it is my personality: I'm a classically trained musician from another life (a MUCH younger life) so you can imagine that I might be predisposed to being a stickler for details.
In the end, I finished this book because it was thorough, clear, deep (the way I like it!) and had great continuity (I am easily confused so this is important to me!).
One of the most frustrating parts of reading techinical books for me has been when the book begins an example, abandons the example and then starts a new one without the author saying something to the effect of, "In this *new* example..." or "I'll use a different example to demonstrate...".
The examples in this book are so continuous that those statements are never even needed.
Mr. McLaughlin very courteously (in my opinion) allows readers to benefit from a well-thought plan (apparently!) of moving smoothly from one technical issue to the next by extending an already developed example. I find this feature to be very reassuring and conducive to quick learning. I mean, code is hard enough to read by itself; much more so when the context of the code switches from page to page or randomly 2,3,4 or 5 pages into an issue.
The way Mr. McLaughlin makes use of code examples in this book is very helpful, too, because it allows the reader to better understand how one technical issue is related to another. As an example: how to use Virtual Directories is included in the chapter on Large Objects. Now, one wouldn't necessarily *only* use Virtual Directories with Large Objects, but it does make sense, and having the subject placed there helps me understand the most common (I assume) real-world application of Virtual Directories.
I would say that this has been an excellent resource for me as a cover-to-cover read and I have already used it as a reference manual so I am sure it works well in that way also.
I hope your experience with this book is as good as mine has been.
Many congratulations and my deepest appreciation to this author!
My first technical book ever!
This is a huge accomplishment for me (and the author!)!!.

2 of 2 found the following review helpful:

5Awesome  Oct 17, 2009
Really good book. Details all the basics and more advanced topics of Pl/SQL. Great read.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 About UsContact Us
 
Web business powered by Amazon WebStore