Oracle PL/SQL: Expert Techniques For Developers and Database Administrators (Charles River Media Programming) [Paperback]

Lakshman Bulusu (Author)

Book Description

ISBN-10: 1584505540 | ISBN-13: 978-1584505549 | Publication Date: April 3, 2008 | Edition: 1

Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards that can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Product Details

• Paperback: 320 pages
• Publisher: Charles River Media; 1 edition (April 3, 2008)
• Language: English
• ISBN-10: 1584505540
• ISBN-13: 978-1584505549
• Product Dimensions: 9.2 x 7.4 x 1 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 2.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #1,494,037 in Books (See Top 100 in Books)
  • #17 in Books > Computers & Technology > Graphic Design > Web Design > Web Graphics

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

2.0 out of 5 stars The search for generic Oracle PL/SQL code starts here, August 17, 2011

By 

Warbird (Minnealopis, MN) - See all my reviews

This review is from: Oracle PL/SQL: Expert Techniques For Developers and Database Administrators (Charles River Media Programming) (Paperback)

I'm surprised no one has reviewed this book on Amazon so far. I did purchase Bulusu's recently and I have found that the "expert" programs are interesting from the point of view of possibly run Oracle 11g PL/SQL code in a generic compute sever mode. I did find the explanations of PL/SQL scripts to be very brief and I would said, "outlines" only. I found bugs in the PL/SQL scripts, for example "Listing 4.4 Performing Data I/O Using an Associative Array" does not compile without errors as published in the book. I also went to the www.courseptr.com website looking for errata and found nothing. Obviously, I will have to analysis and debug the PL/SQL scripts myself and add additional documentation. All that said, the idea of developing generic PL/SQL code for scientific computation and record I/O processing is a good one. I would hope an future edition with present the material in a more comprehensive format.