Oracle PL/SQL for DBAs
PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performa...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Sebastopol, Calif.
O'Reilly
2005
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- FunctionsStructure of a function; Calling a function; Parameters; Defining parameters; Actual and formal parameters; Parameter modes; Packages; Rules for building packages; Rules for calling packaged elements; Package data; Querying Data; Typical Query Operations; Cursor Attributes; Implicit Cursors; Error handling with implicit cursors; Implicit SQL cursor attributes; Explicit Cursors; BULK COLLECT; Limiting rows retrieved with BULK COLLECT; Cursor Variables and REF Cursors; Declaring REF CURSOR types; Declaring cursor variables; Opening cursor variables; Fetching from cursor variables
- Changing DataThe INSERT Statement; The UPDATE Statement; The DELETE Statement; Cursor Attributes for DML Operations; DML and Exception Handling; Bulk DML with the FORALL Statement; Syntax of the FORALL Statement; FORALL Examples; Managing Transactions in PL/SQL; The COMMIT Statement; The ROLLBACK Statement; Autonomous Transactions; Database Triggers; DML Triggers; Transaction participation; Creating a DML trigger; The WHEN clause; Working with NEW and OLD pseudo-records; Determining the DML action within a trigger; DDL Triggers; Creating a DDL Trigger; Database Event Triggers
- IdentifiersNULLs; Literals; String literals; Numeric literals; Boolean literals; The Semicolon Delimiter; Comments; Single-line comment syntax; Multi-line comment syntax; Program Data; Types of PL/SQL Datatypes; Character data; Numbers; Dates, timestamps, and intervals; Booleans; Binary data; ROWIDs; REF CURSOR datatype; Internet datatypes; "Any" datatypes; Declaring Program Data; Declaring a variable; Declaring constants; Anchored declarations; Control Statements; IF Statements; CASE Statements and Expressions; Simple CASE statement; Searched CASE statement; Loops in PL/SQL; Simple Loop
- FOR LoopWHILE Loop; Exception Handling; Defining Exceptions; Raising Exceptions; RAISE statement; Using RAISE_APPLICATION_ERROR; Handling Exceptions; Built-in error functions; Unhandled exceptions; Propagation of an unhandled exception; Records; Declaring Records; Working with Records; Record-level operations; Field-level operations; Collections; Types of Collections; Working with Collections; Using an associative array; Using a nested table; Using a VARRAY; Collection Methods (Built-ins); Procedures, Functions, and Packages; Procedures; Structure of a procedure; Calling a procedure
- Table of Contents; Preface; PL/SQL for DBAs; Securing the Database; Optimizing Performance; Fully Leveraging Oracle Utilities and Features; Mentoring New Developers and DBAs; About This Book; Conventions Used in This Book; About PL/SQL Versions; Resources for Developing PL/SQL Expertise; The O'Reilly PL/SQL Series; PL/SQL on the Internet; About the Code; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; Introduction to PL/SQL; What Is PL/SQL?; Basic PL/SQL Syntax Elements; PL/SQL Block Structure; Sections of the block; Anonymous blocks; The PL/SQL Character Set