Oracle Database 10g PL/SQL Programming

Name: Oracle Database 10g PL/SQL Programming
Brand: McGraw-Hill
Price: 90.59 EUR
Availability: OnlineOnly

Ron Hardman Michael McLaughlin Scott Urman(Autor*in)

McGraw-Hill (Verlag)

1. Auflage

Erschienen am 16. September 2004

791 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-07-150228-3 (ISBN)

90,59 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Oracle Database 10g PL/SQL Programming
Copyright Page
About the Authors
Dedication Page
Contents at a Glance
Contents
Acknowledgments
Introduction
PART I Introduction
1 Introduction to PL/SQL
Introduction to Programming Languages
Note to Beginning Programmers
PL/What?
Structured Query Language (SQL)
Relational Database Overview
PL/SQL vs. SQL
PL/SQL vs. Java
PL/SQL History and Features
Language Fundamentals
Anonymous Blocks
Procedures
Functions
Packages
Object Types
PL/SQL Statement Processing
Interpreted
Native Compilation
Getting the Most from This Book
Audience
Objective
Scope
Assumptions
Conventions
Examples
Summary
2 Using SQL*Plus and JDeveloper
SQL*Plus
Connecting to the Instance
Testing the Connection
Using SQL*Plus
Changing SQL*Plus Session Settings
Running a Script from a File
Output to the Screen Using SQL*Plus and PL/SQL
JDeveloper
Installing JDeveloper
Working with PL/SQL in JDeveloper
Summary
3 PL/SQL Basics
The PL/SQL Block
The Basic Structure
Anonymous Blocks
Named Blocks
Nested Blocks
Triggers
Object Types
Language Rules and Conventions
Lexical Units
PL/SQL Data Types
Scalar
Character/String
NUMBER Data Type
Boolean
Date/Time
Composite
Reference
LOB
Using Variables
%TYPE
%ROWTYPE
Variable Scope
Bind Variables
Hiding Code
Expressions
Assignment Operator
Concatenation Operator
Controlling Program Flow
Conditional Evaluation
Circular Execution
Sequential Navigation using GOTO
Summary
4 Using SQL with PL/SQL
Transaction Processing
Transactions and Locking
Autonomous Transactions
Set Transaction
Retrieving Data
SQL SELECT Statement
Pattern Matching
Information Retrieval
Cursors
How Cursors Work
Explicit Cursors
Implicit Cursors
Cursor Variables
Cursor Subqueries
Open Cursors
DML and DDL
Pre-Compilation
Manipulating Data with DML
DELETE
Introduction to Dynamic SQL
Using ROWID and ROWNUM
ROWID
ROWNUM
Built-in SQL Functions
Character Functions
Numeric Functions
Date Functions
Conversion Functions
Error Functions
Other Functions
Summary
5 Records
Introducing Records
What Is a Record?
Working with Records
Defining Record Types
Defining and Using Record Types as Formal Parameters
Defining and Using Object Types as Parameters
Returning Record Types from Functions
Defining and Using Record Types as Return Values
Defining and Using Object Types as Return Values
Verifying Work with Record Types
Summary
6 Collections
Introducing Collections
What Is a Collection?
Working with Collections
Working with Varrays
Working with Nested Tables
Working with Associative Arrays
Oracle 10g Collection API
COUNT Method
DELETE Method
EXISTS Method
EXTEND Method
FIRST Method
LAST Method
LIMIT Method
NEXT Method
PRIOR Method
TRIM Method
Summary
7 Error Handling
What Is an Exception?
Declaring Exceptions
Raising Exceptions
Handling Exceptions
The EXCEPTION_INIT Pragma
Using RAISE_APPLICATION_ERROR
Exception Propagation
Exceptions Raised in the Executable Section
Exceptions Raised in the Declarative Section
Exceptions Raised in the Exception Section
Exception Guidelines
Scope of Exceptions
Avoiding Unhandled Exceptions
Masking Location of the Error
Exceptions and Transactions
Summary
8 Creating Procedures, Functions, and Packages
Procedures and Functions
Subprogram Creation
Subprogram Parameters
The CALL Statement
Procedures vs. Functions
Packages
Package Specification
Package Body
Packages and Scope
Overloading Packaged Subprograms
Package Initialization
Summary
9 Using Procedures, Functions, and Packages
Subprogram Locations
Stored Subprograms and the Data Dictionary
Local Subprograms
Stored vs. Local Subprograms
Considerations of Stored Subprograms and Packages
Subprogram Dependencies
Package Run-Time State
Privileges and Stored Subprograms
Stored Functions and SQL Statements
Single-Valued Functions
Multiple-Valued Functions
Native Compilation
Pinning in the Shared Pool
KEEP
UNKEEP
SIZES
ABORTED_REQUEST_THRESHOLD
The PL/SQL Wrapper
Summary
10 Database Triggers
Types of Triggers
DML Triggers
Instead-of Triggers
System Triggers
Creating Triggers
Creating DML Triggers
Creating Instead-of Triggers
Creating System Triggers
Other Trigger Issues
Triggers and the Data Dictionary
Mutating Tables
Mutating Table Example
Workaround for the Mutating Table Error
Summary
PART II Advanced PL/SQL Features
11 Intersession Communication
Introducing Intersession Communication
Requiring Permanent or Semipermanent Structures
Not Requiring Permanent or Semipermanent Structures
The DBMS_PIPE Built-in Package
Introducing the DBMS_PIPE Package
Defining the DBMS_PIPE Package
Working with the DBMS_PIPE Package
DBMS_ALERT Built-in Package
Introducing the DBMS_ALERT Package
Defining the DBMS_ALERT Package
Working with the DBMS_ALERT Package
Summary
12 External Routines
Introducing External Procedures
Working with External Procedures
Defining the extproc Architecture
Defining extproc Oracle Net Services Configuration
Defining the Multithreaded External Procedure Agent
Working with a C Shared Library
Working with a Java Shared Library
Troubleshooting the Shared Library
Configuration of the Listener or Environment
Configuration of the Shared Library or PL/SQL Library Wrapper
Summary
13 Dynamic SQL
Introducing Dynamic SQL
Working with Native Dynamic SQL
Working with DDL and DML Without Bind Variables
Working with DML and a Known List of Bind Variables
Working with DQL
Working with the Oracle DBMS_SQL Built-in Package
Working with DDL and DML Without Bind Variables
Working with DML and a Known List of Bind Variables
Working with DQL
Summary
14 Introduction to Objects
Introduction to Object-Oriented Programming
Data and Procedural Abstraction
Object Type Overview
Creating Object Types
Object Type Specification
Object Type Body
Object Type Inheritance
Dynamic Method Dispatch
Attribute Chaining
Making Changes
Type Evolution
Summary
15 Objects in the Database
Introduction to Objects in the Database
Object Tables
Column Objects
Object Views
Accessing Persistent Objects Using SQL and PL/SQL
Object Tables
Accessing Column Objects
Accessing Object Views
Object Related Functions and Operators
Maintaining Persistent Objects
Type Evolution
Summary
16 Large Objects
Introduction to Large Objects
Features Comparison
Types of LOBs
LOB Structure
Internal LOB Storage
External LOB Storage
Temporary LOB Storage
Migrating from LONGs to LOBs
LOBs and SQL
SQL for Internal Persistent LOBs
External LOB - BFILE
LOBs and PL/SQL
DBMS_LOB
Performance Considerations
Returning Clause
Summary
17 Scheduling Tasks
Introducing DBMS_JOB
SUBMIT
BROKEN
RUN
CHANGE
REMOVE
Oracle Scheduler
Terminology
Using DBMS_SCHEDULER
Migrating from DBMS_JOB
Removing a Job
Summary
PART III Appendixes
A PL/SQL Reserved Words
Table of Reserved Words
B Guide to Supplied Packages
SYS-Owned Built-in Packages
DBMS_ADVANCED_REWRITE
DBMS_ADVISOR
DBMS_ALERT
DBMS_APPLICATION_INFO
DBMS_APPLY_ADM
DBMS_AQ
DBMS_BACKUP_RESTORE
DBMS_CAPTURE_ADM
DBMS_CRYPTO
DBMS_DATA_MINING, DBMS_DATA_MINING_TRANSFORM
DBMS_DATAPUMP
DBMS_DDL
DBMS_DEBUG
DBMS_DEFER
DBMS_DESCRIBE
DBMS_DIMENSION
DBMS_DISTRIBUTED_TRUST_ADMIN
DBMS_FGA
DBMS_FILE_TRANSFER
DBMS_FLASHBACK
DBMS_HS
DBMS_HS_PASSTHROUGH
DBMS_JAVA
DBMS_JOB
DBMS_LDAP
DBMS_LOB
DBMS_LOCK
DBMS_LOGMNR
DBMS_METADATA
DBMS_MONITOR
DBMS_OBFUSCATION_TOOLKIT
DBMS_ODCI
DBMS_OFFLINE_OG
DBMS_OLAP
DBMS_OUTLN
DBMS_OUTLN_EDIT
DBMS_OUTPUT
DBMS_PIPE
DBMS_PROFILER
DBMS_PROPAGATION_ADM
DBMS_RANDOM
DBMS_REDEFINITION
DBMS_REFRESH
DBMS_REPAIR
DBMS_REPCAT
DBMS_RESOURCE_MANAGER/DBMS_RESOURCE_MANAGER_PRIVS
DBMS_RESUMABLE
DBMS_ROWID
DBMS_RULE, DBMS_RULE_ADM
DBMS_SCHEDULER
DBMS_SCHEMA_COPY
DBMS_SERVER_ALERT
DBMS_SERVICE
DBMS_SESSION
DBMS_SHARED_POOL
DBMS_SPACE
DBMS_SQL
DBMS_SQLTUNE
DBMS_STANDARD, STANDARD
DBMS_STAT_FUNCS
DBMS_STATS
DBMS_SUMMARY
DBMS_TRACE
DBMS_TRANSACTION
DBMS_TRANSFORM
DBMS_TYPES
DBMS_UTILITY
DBMS_WARNING
DBMS_WORKLOAD_REPOSITORY
DBMS_XMLGEN, DBMS_XMLQUERY
DBMS_XPLAN
UTL_COLL
UTL_COMPRESS
UTL_DBWS
UTL_ENCODE
UTL_FILE
UTL_HTTP
UTL_I18N
UTL_INADDR
UTL_LMS
UTL_MAIL
UTL_RAW
UTL_RECOMP
UTL_REF
UTL_SMTP
UTL_TCP
UTL_URL
CTXSYS-Owned Built-in Packages
CTX_ADM
CTX_CLS
CTX_DDL
CTX_DOC
CTX_OUTPUT
CTX_QUERY
CTX_REPORT
CTX_THES
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken