Expert Oracle PL/SQL (Paperback)

Ron Hardman, Michael McLaughlin

  • 出版商: McGraw-Hill Education
  • 出版日期: 2005-09-01
  • 售價: $2,070
  • 貴賓價: 9.5$1,967
  • 語言: 英文
  • 頁數: 496
  • 裝訂: Paperback
  • ISBN: 0072261943
  • ISBN-13: 9780072261943
  • 相關分類: OracleSQL
  • 已絕版





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.


Table of Contents:

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