From the eBook - Fifth edition.
Copyright; Table of Contents; Oracle PL/SQL Language Pocket Reference; 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 StatementsLoops; Simple Loop; Numeric FOR Loop; Cursor FOR Loop; WHILE Loop; "Repeat Until" Loop Emulation; EXIT Statement; CONTINUE Statement; Loop Labels; Database Interaction; Sequences in PL/SQL; Transaction Management; Autonomous Transactions; Cursors in PL/SQL; Explicit Cursors; Implicit Cursors; Native Dynamic SQL; 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 a Record's Fields; Assigning Records
Records and DMLNested 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; 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 TriggersDDL 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; Improving Performance of Calling PL/SQL Functions from SQL; Column Name Versus 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 CompilerPerforming Native Compilation of PL/SQL; Java Language Integration; Example; Publishing Java to PL/SQL; Data Dictionary; Index
PL/SQL Language Fundamentals
Variables and Program Data
Conditional and Sequential Control
Built-in Functions and Packages
Stored Procedures and Functions
Calling PL/SQL Functions in SQL
Java Language Integration.
