• 
  • Weitere Informationen zu diesem Buch:

    Inhaltsverzeichnis | Index |

	


      Introduction  

                Acknowledgments  

                Conventions  

      PL/SQL Language Fundamentals  

                PL/SQL Character Set  

                Identifiers  

                Boolean, Numeric, and String Literals  

                Numeric Literals  

                Datetime Interval Literals  

                Delimiters  

                Comments  

                Pragmas  

                Statements  

                Block Structure  

      Variables and Program Data  

                Scalar Datatypes  

                LOB Datatypes  

                Implicit Datatype Conversions  

                NULLs in PL/SQL  

                Declaring Variables  

                Anchored Declarations  

                Programmer-Defined Subtypes  

      Conditional and Sequential Control  

                Conditional Control Statements  

                Sequential Control Statements  

      Loops  

                Simple Loop  

                Numeric FOR Loop  

                Cursor FOR Loop  

                WHILE Loop  

                REPEAT UNTIL Loop Emulation  

                EXIT Statement  

                CONTINUE Statement (Oracle Database 11g)  

                Loop Labels  

      Database Interaction  

                Sequences in PLSQL  

                Transaction Management  

                Autonomous Transactions  

      Cursors in PL/SQL  

                Explicit Cursors  

                Implicit Cursors  

                Dynamic Cursors  

                DBMS_SQL  

                SQL Injection and Bind Variables  

                Cursor Variables  

                Cursor Expressions  

      Exception Handling  

                Declaring Exceptions  

                Raising Exceptions  

                Scope  

                Propagation  

      Records in PL/SQL  

                Declaring Records  

                Referencing Fields of Records  

                Assigning Records  

                Records and DML  

                Nested Records  

      Collections in PL/SQL  

                Declaring a Collection  

                Initializing a Collection  

                Adding and Removing Elements  

                Nested Table Functions  

                Collection Methods  

                Collections and Privileges  

                Nested Collections  

                Bulk Binds  

      Built-in Functions and Packages  

                Built-in Functions  

                Built-in Regular Expression Functions  

                Built-in Packages  

      Stored Procedures and Functions  

                Procedures  

                Functions  

                Parameters  

                Local Programs  

                Program Overloading  

                Forward Declarations  

                Table Functions  

                Function Result Cache  

                Privileges and Stored PL/SQL  

      Triggers  

                Creating Triggers  

                Trigger Predicates  

                DML Events  

                Compound DML Triggers  

                DDL Events  

                Database Events  

      Packages  

                Package Structure  

                Referencing Package Elements  

                Package Data  

                SERIALLY_REUSABLE Pragma  

                Package Initialization  

      Calling PL/SQL Functions in SQL  

                Calling a Function  

                Calling Packaged Functions in SQL  

                Column/Function Name Precedence  

      Object-Oriented Features  

                Object Types  

                Type Inheritance  

                Methods  

                Methods in Subtypes  

                Manipulating Objects in PL/SQL and SQL  

                Upcasting and Downcasting  

                Changing Object Types  

      Compilation  

                Compiling Stored PL/SQL Programs  

                Conditional Compilation  

                Compiler Warnings  

                Optimizing Compiler  

                Performing Native Compilation of PL/SQL  

      Java Language Integration  

                Example  

                Publishing Java to PL/SQL  

                Data Dictionary  
Index