CDN$ 5.34
  • List Price: CDN$ 74.95
  • You Save: CDN$ 69.61 (93%)
FREE Shipping on orders over CDN$ 25.
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Expert Oracle PL/SQL has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Expert Oracle PL/SQL Paperback – Oct 3 2005

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 5.34
CDN$ 5.34 CDN$ 7.07

Save an Additional 10% on Textbooks When you Join Amazon Student

Special Offers and Product Promotions

  • Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)
  • Visit the McGraw-Hill Technical Store for resources to learn more and do more.

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Product Details

  • Paperback: 496 pages
  • Publisher: McGraw-Hill Education; 1 edition (Oct. 3 2005)
  • Language: English
  • ISBN-10: 0072261943
  • ISBN-13: 978-0072261943
  • Product Dimensions: 18.5 x 2.6 x 23.1 cm
  • Shipping Weight: 898 g
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #2,026,293 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

Product Description

From the Back Cover

Create and debug next-generation, feature-rich PL/SQL applications

Push your PL/SQL programming skills to the next level with the extensive information contained in this volume. You’ll learn how to write dynamic PL/SQL programs, interface with Oracle databases, execute complex calculations, and handle error conditions using advanced techniques. Plus, you’ll get the latest on the PL/SQL Toolkit, Java integration, code threading, and performance optimizing. Oracle professionals Ron Hardman and Michael McLaughlin cover all the bases, providing real-world examples, undocumented tricks, syntax samples, and unique solutions for every topic.

  • Compile high performance PL/SQL scripts using procedures, functions, packages and triggers
  • Trap, trace, identify, and eliminate compile-time and runtime errors
  • Manage error propagation, stacks, regular expressions, and metacharacters
  • Exploit definer’s-rights and invoker’s-rights architectures
  • Extend PL/SQL functionality using server-side and internal Java class libraries
  • Build and run parallel PL/SQL program units using DBMS_JOB and DBMS_PIPE
  • Exploit definer’s-rights and invoker’s-rights architectures
  • Tune performance using statistics gathering, the PL/SQL optimizer, SQL Trace, DBMS_STATS, and TKPROF
  • Use Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching
  • Administer server-side PL/SQL Toolkit web pages and PL/SQL Server Pages
  • Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER

About the Author

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) HASH(0x9ac52b34) out of 5 stars 3 reviews
10 of 13 people found the following review helpful
HASH(0x9946feac) out of 5 stars Beyond the Basics March 4 2006
By John Matlock - Published on
Format: Paperback
Note the word Expert in the title of this book. This is not where you would turn to learn how to write a simple SELECT statement. This book presumes that you have a basic fundamental knowledge of how Oracle and SQL work together. The emphasis here is on the lessor used features, the newest additions to 10g Release 2, in short the information beyond what the basic programmer knowledge that helps to define the expert.

In addition to the standard programming tips, this book goes beyond the basics to look at what the database itself is doing. With more knowledge here, you can better understand what the database itself is doing when it is working on your SQL statements.

Although virtually all databases now use SQL as their basic programming language, each of the big database programs has additions or differences that make that particular version of SQL just a bit different from others. In this book, the authors concentrate on those special features as implemented by Oracle.
2 of 2 people found the following review helpful
HASH(0x99bdbdd4) out of 5 stars Random spattering of PL/SQL technique March 16 2010
By V. Hall - Published on
Format: Paperback Verified Purchase
This book seemed more like a few seemingly random techniques and tasks that PL/SQL is suited for rather than diving into more general and yet advanced programming. It was useful to gleam some of the ideas used, but it seemed more like longwinded and specific tasks using PL. The book was otherwise organized and well written.

If you need to buy just one book diving into advanced techniques look elsewhere, but for someone with a large collection this may be a good addition.
2 of 3 people found the following review helpful
HASH(0x99bdbbdc) out of 5 stars Not what I needed Oct. 28 2008
By whopado - Published on
Format: Paperback
As a professional PL/SQL developer, I try to keep abreast of the latest and greatest techniques for accomplishing what my clients need done. This book did not provide me with much I could use. Most of it is the kind of obscure bit-twiddling that Object Oriented gurus seem to revel in. If you are a Java or C fan that wants to beat the procedural/relational PL/SQL language to fit into your OO world, you may like this book better than I did. There was some good info about tuning, but I would not buy the book for that alone.