Oracle PL/SQL Expert Techniques... | Buy

Summary

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.

Introductory Concepts
Introduction 5 pages
PL/SQL by dissection 20 pages
Program Structure Internal Representation Memory Usage
Program Compilation
Program Execution Meta-data for PL/SQL code
Program Debugging Protecting Source Code
New features in PL/SQL 10 pages
New features in Oracle10g
New features in Oracle11g
Techniques for PL/SQL Programming
Data Structure Management in PL/SQL 30 pages
Techniques for using Records
Techniques for using Associative Arrays
Techniques for using Nested Tables
Techniques for using VARRAYS Simulating Multi-Dimensional Arrays
Techniques for using Objects as Data Structures Records vs Objects
Error Management in PL/SQL 20 pages
Techniques to obtain complete error info
Techniques to customize error info returned
Techniques to halt further processing on error occurrence
Data Management in PL/SQL 40 pages
Data Retrieval Techniques
Data Manipulation Techniques
Dynamic SQL and PL/SQL techniques
Array Processing using static SQL
Array Processing using dynamic SQL
Techniques for using DDL in PL/SQL
Application Management in PL/SQL 40 pages
Procedures Vs Functions
When to use what
User-defined operators Vs Functions
When to use what Coding packages to globalize data and code
Packages vs Contexts
When to use what to globalize data
Reading and Writing package variables dynamically
Coding packages to localize data and privatize code
Coding packages to break dependency chain Coding packages to pass data between applications
Sharing data using collections vs sharing data using
REF CURSORS Supplementing application logic with data integrity using triggers
Packages Vs Objects as application structures
Transaction management in PL/SQL 15 pages
Asynchronous COMMIT
Autonomous transaction techniques
Techniques for auditing queries
Applying PL/SQL in the real world
Application Development Frameworks using PL/SQL	p. 40 pages
Application Development
Framework Error Handling
Framework DML Auditing
Framework File I/O
Framework ETL
Framework Performance Tuning Framework
Applying PL/SQL in 3GL and Web environment 30 pages
Extending PL/SQL to use Java
Extending PL/SQL to use C and C++
Extending PL/SQL to use HTML
HTML in PL/SQL vs PL/SQL in HTML
Emailing techniques in PL/SQL UTL_MAIL vs UTL_SMTP
When to use what
Miscellaneous Techniques 20 pages
Simulating datasets using pipelined table functions
Auto-generating code using dynamic
SQL and/or PL/SQL Hiding statically written and dynamically generated PL/SQL Code
Batch Scheduling of OS command jobs
PL/SQL Tuning and Debugging 30 pages
Tuning Data Structures
Tuning Procedural Code
Techniques for Debugging PL/SQL
PL/SQL Coding Standards 10 pages
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.