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; Using Code Examples; Safari?? Books Online; Comments and Questions; Acknowledgments; 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 Navigating the Database; 2.2 Creating and Editing Source Code; 2.3 SQL*Plus; 2.4 Performing Essential PL/SQL Tasks; 2.5 Editing Environments for PL/SQL; 2.6 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; 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 The CONTINUE Statement; 5.8 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; 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 Operators; 9.4 Numeric Functions; Chapter 10: Dates and Timestamps; 10.1 Datetime Datatypes; 10.2 Getting the Current 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 Function Quick Reference; 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; SQL in PL/SQL; Chapter 14: DML and Transaction Management; 14.1 DML in PL/SQL; 14.2 Transaction Management; 14.3 Autonomous Transactions; Chapter 15: Data Retrieval; 15.1 Cursor Basics; 15.2 Working with Implicit Cursors; 15.3 Working with Explicit Cursors; 15.4 SELECT...FOR UPDATE; 15.5 Cursor Variables and REF CURSORs; 15.6 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 Oracle Database 11g New Features; 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 or Nested 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 Managing Dependencies and Recompiling Code; 20.3 Compile-Time Warnings; 20.4 Testing PL/SQL Programs; 20.5 Tracing PL/SQL Execution; 20.6 Debugging PL/SQL Programs; 20.7 Protecting Stored Code; 20.8 Introduction to Edition-Based Redefinition (Oracle Database 11g Release 2); Chapter 21: Optimizing PL/SQL Performance; 21.1 Tools to Assist in Optimizatioooooon; 21.2 The Optimizing Compiler; 21.3 Data Caching Techniques; 21.4 Bulk Processing for Multirow SQL; 21.5 Improving Performance With Pipelined Table Functions; 21.6 Specialized Optimization Techniques; 21.7 Stepping Back for the Big Picture on Performance; Chapter 22: I/O and PL/SQL; 22.1 Displaying Information; 22.2 Reading and Writing Files; 22.3 Sending Email; 22.4 Working with Web-Based Data (HTTP); 22.5 Other Types of I/O Available in PL/SQL; Advanced PL/SQL Topics; Chapter 23: Application Security and PL/SQL; 23.1 Security Overview; 23.2 Encryption; 23.3 Row-Level Security; 23.4 Application Contexts; 23.5 Fine-Grained Auditing; Chapter 24: PL/SQL Architecture; 24.1 Who (or What) is DIANA?; 24.2 How Does Oracle Execute PL/SQL Code?; 24.3 The Default Packages of PL/SQL; 24.4 Execution Authority Models; 24.5 Conditional Compilation; 24.6 PL/SQL and Database Instance Memory; 24.7 Native Compilation; 24.8 What You Need to Know; Chapter 25: Globalization and Localization in PL/SQL; 25.1 Overview and Terminology; 25.2 Unicode Primer; 25.3 Character Semantics; 25.4 String Sort Order; 25.5 Multilingual Information Retrieval; 25.6 Date/Time; 25.7 Currency Conversion; 25.8 Globalization Development Kit for PL/SQL; Chapter 26: Object-Oriented Aspects of PL/SQL; 26.1 Introduction to Oracle???s Object Features; 26.2 Object Types by Example; 26.3 Object Views; 26.4 Maintaining Object Types and Object Views; 26.5 Concluding Thoughts from a (Mostly) Relational Developer; Chapter 27: Calling Java from PL/SQL; 27.1 Oracle and Java; 27.2 Getting Ready to Use Java in Oracle; 27.3 A Simple Demonstration; 27.4 Using loadjava; 27.5 Using dropjava; 27.6 Managing Java in the Database; 27.7 Using DBMS_JAVA; 27.8 Publishing and Using Java in PL/SQL; Chapter 28: External Procedures; 28.1 Introduction to External Procedures; 28.2 The Oracle Net Configuration; 28.3 Setting Up Multithreaded Mode; 28.4 Creating an Oracle Library; 28.5 Writing the Call Specification; 28.6 Raising an Exception from the Called C Program; 28.7 Nondefault Agents; 28.8 Maintaining External Procedures; Regular Expression Metacharacters and Function Parameters; Metacharacters; Functions and Parameters; Number Format Models; Date Format Models; Colophon;