Product Description

Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

Product Details

• Amazon Sales Rank: #410184 in Books
• Published on: 2005-09-12
• Original language: English
• Number of items: 1
• Binding: Paperback
• 496 pages

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
Ron Hardman, OCP, is a Consulting Technical Specialist with Oracle Worldwide Technical Support. Prior to joining Oracle Corporation, he was an Oracle database developer and consultant. He is a frequent presenter on the topics of Oracle Text and Ultrasearch at Oracle User Group conferences, and teaches classes on SQL and PL/SQL. He is the coauthor of Oracle Database 10g PL/SQL Programming and has published articles with Oracle Magazine and other online magazines on subjects related to information retrieval.

Michael McLaughlin, D. CS., is the Senior Application Upgrade Manager for Oracle Applications Release Engineering. He is currently working on the upgrade architecture for the next release of Oracle Applications. He has worked with PL/SQL since its first version in Oracle 6, and has authored customer support notes on customizing Oracle Applications with Pro*C and PL/SQL. He has taught computer science and information technology at Regis University and Colorado Technical University, including courses in database development, SQL, PL/SQL, and Java. He is the coauthor of Oracle Database 10g PL/SQL Programming.

Customer Reviews

Beyond the Basics
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.

Not what I needed
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.