|
Oracle PL/SQL Language Pocket Reference 4th Edition
The fourth edition of this popular pocket guide provides
quick-reference information that will help you use Oracle's
PL/SQL language, including the newest Oracle Database 11g
features. It's a companion to Steven Feuerstein and Bill
Pribyl's bestselling Oracle PL/SQL Programming.
This concise guide boils down the most
vital PL/SQL
information into an accessible summary of:
Fundamental language elements (e.g., block structure,
datatypes, declarations)
Statements for program control, cursor management, and
exception handling
Records, procedures, functions, triggers, and packages
Calling PL/SQL functions in SQL
Compilation options, object-oriented features, collections,
and Java integration
The new edition describes such Oracle Database 11g elements
as PL/SQL's function result cache, compound triggers, the
CONTINUE statement, the SIMPLE_INTEGER datatype, and
improvements to native compilation, regular expressions, and
compiler optimization (including intra-unit inlining). In
addition, this book now includes substantial new sections on
Oracle's built-in functions and packages.
When you need answers quickly, the Oracle PL/SQL Language
Pocket Reference will save you hours of frustration.
CONTENTS:
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
|
