Oracle PL/SQL Programming

Dedication; Preface; Objectives of This Book; Structure of This Book; Conventions Used in This Book; Which Platform or Version?; About the Code; Safari Enabled; Comments and Questions; Acknowledgments; Part I: Programming in PL/SQL; Chapter 1: Introduction to PL/SQL; 1.1 What Is PL/SQL?; 1.2 The Origins of PL/SQL; 1.3 So This Is PL/SQL; 1.4 About PL/SQL Versions; 1.5 Resources for PL/SQL Developers; 1.6 Some Words of Advice; Chapter 2: Creating and Running PL/SQL Code; 2.1 SQL*Plus; 2.2 Performing Essential PL/SQL Tasks; 2.3 Calling PL/SQL from Other Languages; Chapter 3: Language Fundamentals; 3.1 PL/SQL Block Structure; 3.2 The PL/SQL Character Set; 3.3 Identifiers; 3.4 Literals; 3.5 The Semicolon Delimiter; 3.6 Comments; 3.7 The PRAGMA Keyword; 3.8 Labels; Part II: PL/SQL Program Structure; Chapter 4: Conditional and Sequential Control; 4.1 IF Statements; 4.2 CASE Statements and Expressions; 4.3 The GOTO Statement; 4.4 The NULL Statement; Chapter 5: Iterative Processing with Loops; 5.1 Loop Basics; 5.2 The Simple Loop; 5.3 The WHILE Loop; 5.4 The Numeric FOR Loop; 5.5 The Cursor FOR Loop; 5.6 Loop Labels; 5.7 Tips for Iterative Processing; Chapter 6: Exception Handlers; 6.1 Exception-Handling Concepts and Terminology; 6.2 Defining Exceptions; 6.3 Raising Exceptions; 6.4 Handling Exceptions; 6.5 Building an Effective Error Management Architecture; 6.6 Making the Most of PL/SQL Error Management; Part III: PL/SQL Program Data; Chapter 7: Working with Program Data; 7.1 Naming Your Program Data; 7.2 Overview of PL/SQL Datatypes; 7.3 Declaring Program Data; 7.4 Programmer-Defined Subtypes; 7.5 Conversion Between Datatypes; Chapter 8: Strings; 8.1 String Datatypes; 8.2 Working with Strings; 8.3 String Function Quick Reference; Chapter 9: Numbers; 9.1 Numeric Datatypes; 9.2 Number Conversions; 9.3 Numeric Functions; Chapter 10: Dates and Timestamps; 10.1 Datetime Datatypes; 10.2 Getting the Date and Time; 10.3 Interval Datatypes; 10.4 Datetime Conversions; 10.5 Date and Timestamp Literals; 10.6 Interval Conversions; 10.7 Interval Literals; 10.8 CAST and EXTRACT; 10.9 Datetime Arithmetic; 10.10 Date/Time Functions; Chapter 11: Records; 11.1 Records in PL/SQL; Chapter 12: Collections; 12.1 Collections Overview; 12.2 Collection Methods (Built-Ins); 12.3 Working with Collections; 12.4 Nested Table Multiset Operations; 12.5 Maintaining Schema-Level Collections; Chapter 13: Miscellaneous Datatypes; 13.1 The BOOLEAN Datatype; 13.2 The RAW Datatype; 13.3 The UROWID and ROWID Datatypes; 13.4 The LOB Datatypes; 13.5 Working with LOBs; 13.6 Predefined Object Types; Part IV: SQL in PL/SQL; Chapter 14: DML and Transaction Management; 14.1 DML in PL/SQL; 14.2 Bulk DML with the FORALL Statement; 14.3 Transaction Management; 14.4 Autonomous Transactions; Chapter 15: Data Retrieval; 15.1 Cursor Basics; 15.2 Working with Implicit Cursors; 15.3 Working with Explicit Cursors; 15.4 BULK COLLECT; 15.5 SELECT ... FOR UPDATE; 15.6 Cursor Variables and REF CURSORs; 15.7 Cursor Expressions; Chapter 16: Dynamic SQL and Dynamic PL/SQL; 16.1 NDS Statements; 16.2 Binding Variables; 16.3 Working with Objects and Collections; 16.4 Dynamic PL/SQL; 16.5 Recommendations for NDS; 16.6 When to Use DBMS_SQL; 16.7 NDS Utility Package; Part V: PL/SQL Application Construction; Chapter 17: Procedures, Functions, and Parameters; 17.1 Modular Code; 17.2 Procedures; 17.3 Functions; 17.4 Parameters; 17.5 Local Modules; 17.6 Module Overloading; 17.7 Forward Declarations; 17.8 Advanced Topics; 17.9 Go Forth and Modularize!; Chapter 18: Packages; 18.1 Why Packages?; 18.2 Rules for Building Packages; 18.3 Rules for Calling Packaged Elements; 18.4 Working with Package Data; 18.5 When to Use Packages; 18.6 Packages and Object Types; Chapter 19: Triggers; 19.1 DML Triggers; 19.2 DDL Triggers; 19.3 Database Event Triggers; 19.4 INSTEAD OF Triggers; 19.5 AFTER SUSPEND Triggers; 19.6 Maintaining Triggers; Chapter 20: Managing PL/SQL Code; 20.1 Managing Code in the Database; 20.2 Using Native Compilation; 20.3 Using the Optimizing Compiler and Compile-Time Warnings; 20.4 Conditional Compilation; 20.5 Testing PL/SQL Programs; 20.6 Debugging PL/SQL Programs; 20.7 Tuning PL/SQL Programs; 20.8 Protecting Stored Code; Chapter 21: I/O and PL/SQL; 21.1 Displaying Information; 21.2 Reading and Writing Files; 21.3 Sending Email; 21.4 Working with Web-Based Data (HTTP); 21.5 Other Types of I/O Available in PL/SQL; Part VI: Advanced PL/SQL Topics; Chaptttttter 22: Application Security and PL/SQL; 22.1 Security Overview; 22.2 Encryption; 22.3 Row-Level Security; 22.4 Application Contexts; 22.5 Fine-Grained Auditing; Chapter 23: Inside PL/SQL; 23.1 Looking Under the Hood; 23.2 PL/SQL's Optimizing Compiler; 23.3 Dependency Management; 23.4 Execution Authority Models; 23.5 PL/SQL and Oracle Memory; 23.6 Server-Side PL/SQL Processing: Reprise; 23.7 What You Need to Know; Chapter 24: Globalization and Localization in PL/SQL; 24.1 Overview and Terminology; 24.2 Unicode Primer; 24.3 Character Semantics; 24.4 String Sort Order; 24.5 Multilingual Information Retrieval; 24.6 Date/Time; 24.7 Currency Conversion; 24.8 Globalization Development Kit for PL/SQL; Chapter 25: Object-Oriented Aspects of PL/SQL; 25.1 Introduction to Oracle's Object Features; 25.2 An Extended Example; 25.3 Object Views; 25.4 Maintaining Object Types and Object Views; 25.5 Pontifications; Chapter 26: Calling Java from PL/SQL; 26.1 Oracle and Java; 26.2 Getting Ready to Use Java in Oracle; 26.3 A Simple Demonstration; 26.4 Using loadjava; 26.5 Using dropjava; 26.6 Managing Java in the Database; 26.7 Using DBMS_JAVA; 26.8 Publishing and Using Java in PL/SQL; Chapter 27: External Procedures; 27.1 Introduction to External Procedures; 27.2 The Oracle Net Configuration; 27.3 Setting Up Multithreaded Mode; 27.4 Creating an Oracle Library; 27.5 Writing the Call Specification; 27.6 Raising an Exception from the Called C Program; 27.7 Nondefault Agents; 27.8 Maintaining External Procedures; Part VII: Appendixes; Appendix A: Regular Expression Metacharacters and Function Parameters; A.1 Metacharacters; A.2 Function Parameters; Appendix B: Number Format Models; Appendix C: Date Format Models; Colophon;