Oracle PL/SQL Language Pocket Reference
4th Edition
Published on 27. November 2007
Book
178 pages
978-0-596-51404-4 (ISBN)
Description
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.
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.
More details
Other editions
New editions
Steven Feurstein | Bill Pribyl | Chip Dawes
Oracle PL/SQL Language Pocket Reference, 5E
A Guide to Oracle's PL/SQL Language Fundamentals
Book
10/2015
5th Edition
O'Reilly
€19.00
Shipment within 10-20 days
Previous edition
Steven Feuerstein | Bill Pribyl | Chip Dawes
Oracle PL/SQL Language Pocket Reference
Book
05/2004
3rd Edition
O'Reilly
€8.50
Article exhausted; check for reprint
Persons
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including "Oracle PL/SQL Programming" and "Oracle PL/SQL Best Practices" (both O'Reilly). He has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the most popular pages on the Oracle Technology Network and he writes regularly for Oracle Magazine.Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, one of Bill's current nonbillable titles include Webmaster for his neighborhood civic club.Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. Currently a consultant with D&D Technologies, a Chicago consultancy, he works with, lectures on, and writes about Oracle database administration, client server application development, and Unix system administration.
Content
Inhaltsverzeichnis
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
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