Expert Oracle PL/SQL

0.0

Learn how to write dynamic PL/SQL programs, interface with Oracle databases, execute complex calculations, and handle error conditions using advanced techniques. Plus, get the latest on the PL/SQL Toolkit, Java integration, code threading, and performance optimizing. It covers all the bases, providing real-world examples,undocumented tricks, syntax samples, and unique solutions for every topic.

0.0

Ron Hardman OCP, is a Consulting Technical Specialist with Oracle Worldwide Technical Support. Michael McLaughlin, D. CS., is the Senior Application Upgrade Manager for Oracle Applications Release Engineering. Table of Contents Part I: PL/SQL Advanced Concepts, Internals, and Debugging Chapter 1: Introduction to Advanced Concepts, Patterns, and Techniques Chapter 2: PL/SQL Internals Chapter 3: Debugging PL/SQL Applications Part II: Invoker Rights, Java Libraries, and Object Patterns Chapter 4: Invoker's-Rights Architecture Chapter 5: Extending PL/SQL with Java Libraries Chapter 6: Implementing PL/SQL Objects Part III: Optimizing PL/SQL Solutions Chapter 7: Threading PL/SQL Execution Chapter 8: High Performance PL/SQL Part IV: Text Management Using PL/SQL Chapter 9: Introduction to Information Retrieval Chapter 10: Introduction to Regular Expressions Part V: PL/SQL Server Pages and Database Management Chapter 11: Leveraging the PL/SQL Toolkit Chapter 12: Managing the Database Appendix A: REGULAR EXPRESSION METACHARACTERS AND FUNCTIONS Appendix B: ORACLE TEXT SUPPLIED PACKAGES Appendix C: PL/SQL TOOLKIT PACKAGES Appendix D: BASIC PRIMER ON JAVA AND JAVA DATABASE CONNECTIVITY (JDBC) INDEX