Sumário Itens Encontrados: 116Introduction 1Acknowledgments 1Conventions 2PL/SQL Language Fundamentals 2PL/SQL Character Set 2Identifiers 3Boolean, Numeric, and String Literals 4Numeric Literals 5Datetime Interval Literals 6Delimiters 6Comments 8Pragmas 8Statements 9Block Structure 9Variables and Program Data 11Scalar Datatypes 12LOB Datatypes 18Implicit Datatype Conversions 19NULLs in PL/SQL 19Declaring Variables 19Anchored Declarations 22Programmer-Defined Subtypes 23Conditional and Sequential Control 23Conditional Control Statements 23Sequential Control Statements 27Loops 28Simple Loop 29Numeric FOR Loop 29Cursor FOR Loop 30WHILE Loop 30REPEAT UNTIL Loop Emulation 31EXIT Statement 31CONTINUE Statement (Oracle Database 11g) 31Loop Labels 33Database Interaction 34Sequences in PLSQL 34Transaction Management 34Autonomous Transactions 37Cursors in PL/SQL 38Explicit Cursors 38Implicit Cursors 42Dynamic Cursors 45DBMS_SQL 46SQL Injection and Bind Variables 47Cursor Variables 48Cursor Expressions 49Exception Handling 50Declaring Exceptions 51Raising Exceptions 53Scope 54Propagation 54Records in PL/SQL 56Declaring Records 57Referencing Fields of Records 58Assigning Records 58Records and DML 59Nested Records 60Collections in PL/SQL 61Declaring a Collection 63Initializing a Collection 64Adding and Removing Elements 65Nested Table Functions 65Collection Methods 68Collections and Privileges 71Nested Collections 71Bulk Binds 71Built-in Functions and Packages 75Built-in Functions 75Built-in Regular Expression Functions 87Built-in Packages 93Stored Procedures and Functions 97Procedures 98Functions 99Parameters 100Local Programs 103Program Overloading 104Forward Declarations 106Table Functions 106Function Result Cache 107Privileges and Stored PL/SQL 109Triggers 109Creating Triggers 110Trigger Predicates 114DML Events 114Compound DML Triggers 115DDL Events 117Database Events 117Packages 117Package Structure 118Referencing Package Elements 120Package Data 120SERIALLY_REUSABLE Pragma 120Package Initialization 121Calling PL/SQL Functions in SQL 122Calling a Function 123Calling Packaged Functions in SQL 124Column/Function Name Precedence 125Object-Oriented Features 125Object Types 126Type Inheritance 128Methods 128Methods in Subtypes 132Manipulating Objects in PL/SQL and SQL 133Upcasting and Downcasting 135Changing Object Types 138Compilation 139Compiling Stored PL/SQL Programs 140Conditional Compilation 142Compiler Warnings 145Optimizing Compiler 147Performing Native Compilation of PL/SQL 149Java Language Integration 152Example 153Publishing Java to PL/SQL 154Data Dictionary 155Index 157