Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
Inhaltsverzeichnis
<H2>Part I: PL/SQL Advanced Concepts, Internals, and Debugging<H3>Chapter 1: Introduction to Advanced Concepts, Patterns, and Techniques<H3>Chapter 2: PL/SQL Internals<H3>Chapter 3: Debugging PL/SQL Applications<H2>Part II: Invoker Rights, Java Libraries, and Object Patterns<H3>Chapter 4: Invoker's-Rights Architecture<H3>Chapter 5: Extending PL/SQL with Java Libraries<H3>Chapter 6: Implementing PL/SQL Objects<H2>Part III: Optimizing PL/SQL Solutions<H3>Chapter 7: Threading PL/SQL Execution<H3>Chapter 8: High Performance PL/SQL<H2>Part IV: Text Management Using PL/SQL<H3>Chapter 9: Introduction to Information Retrieval<H3>Chapter 10: Introduction to Regular Expressions<H2>Part V: PL/SQL Server Pages and Database Management<H3>Chapter 11: Leveraging the PL/SQL Toolkit<H3>Chapter 12: Managing the Database<H4>Appendix A: REGULAR EXPRESSION METACHARACTERS AND FUNCTIONS<H4>Appendix B: ORACLE TEXT SUPPLIED PACKAGES<H4>Appendix C: PL/SQL TOOLKIT PACKAGES<H4>Appendix D: BASIC PRIMER ON JAVA AND JAVA DATABASE CONNECTIVITY (JDBC)<H4>INDEX