Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) [Paperback]

Michael McLaughlin (Author), John Harper (Author)

Book Description

Publication Date: January 20, 2010 | ISBN-10: 0071493697 | ISBN-13: 978-0071493697 | Edition: 1

Ramp Up Your PL/SQL Programming Skills

Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.

• Understand the Oracle development architecture and the mechanics of connections
• Work with data types, structures, blocks, cursors, and PL/SQL semantics
• Write, deploy, and use functions, procedures, and packages
• Manage transactions and more
• Use dynamic SQL statements in real-world applications
• Support online transaction processing and data warehousing applications with external tables
• Find syntax samples and best practices to solve problems
• Write, deploy, and use object types

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Editorial Reviews

About the Author

Michael McLaughlin is a professor at Brigham Young University-Idaho in the Computer Information Technology Department of the Business and Communication School. He is the author of Oracle Database 11g PL/SQL Programming and other titles.

John M. Harper is a database professional with 10 years of Oracle experience. He is currently a senior lead engineer at the Church of Jesus Christ of Latter-day Saints.

Product Details

• Paperback: 512 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (January 20, 2010)
• Language: English
• ISBN-10: 0071493697
• ISBN-13: 978-0071493697
• Product Dimensions: 9.2 x 7.4 x 1 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #413,879 in Books (See Top 100 in Books)
  • #33 in Books > Computers & Technology > Databases > Oracle

Customer Reviews

Most Helpful Customer Reviews

5 of 7 people found the following review helpful:

3.0 out of 5 stars good, but same standard complaints, December 27, 2010

By 

much2learn - See all my reviews

Amazon Verified Purchase

This review is from: Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) (Paperback)

This book has the same issues for programming newbies as other books of this type (yes, even in the 'for Dummies' books).

The issues are as follows.
1. New terminology/functions is introduced without being fully explained in the text nor is there a reference to where this information can be found.
2. Code samples contain code that has not been covered yet or contains exceptions to the rules being taught.
3. As new information is taught, the sample code for that particular section contains too many differneces from the code used in the sample code from the immediately preceeding section.

The first one is frustrating but a quick search on-line can usually give a more thorough definition of a term or the syntax for a funtion (c.f. try to find "guard-on-entry loop").

The last two are the more trying because the sample code is not really searchable. Samples code should build on previous examples and only introduce the new coding currently being covered. Too many new and unexplained functions, clauses, or statements confuse the newbie.

5 of 7 people found the following review helpful:

5.0 out of 5 stars Oracle Developer, you need this book!, March 10, 2010

By 

Clay L. Christensen (USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) (Paperback)

This book is essential for Oracle veteran and beginner alike. It wraps all the best practices and new features into an easy to read, example laden, treasure of insight into PL/SQL on 11g. A must for all. It is like having a friend who is ready when you need him to point out the new, give you an example, and teach you the pit falls and best practices that you may not think of otherwise.

4 of 6 people found the following review helpful:

5.0 out of 5 stars Review for Oracle Database 11g PL/SQL Programming Workbook, March 8, 2010

By 

E. Kline "Biker/DBA" (Huyetts, MD) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) (Paperback)

Product is perfect for folks who have used PL/SQL for years as a refresher and way to catch up on/practice the art of PL/SQL as well as see whats new!