Skip to content

Oracle Built-In Packages Oracle Development Languages

Best in textbook rentals since 2012!

ISBN-10: 1565923758

ISBN-13: 9781565923751

Edition: 1998

Authors: Steven Feuerstein, Charles Dye, John Beresniewicz, Charles Dye

List price: $49.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Oracle Built-in Packages is the first and only comprehensive reference to the Oracle built-in packages. It pulls together information about how to use the call interface to the built-ins, explains the implementation details, and supplies extensive examples on using the built-in packages effectively. It includes coverage of Oracle's distributed database packages, as well as the newest Oracle8 packages.
Customers also bought

Book details

List price: $49.95
Copyright year: 1998
Publisher: O'Reilly Media, Incorporated
Publication date: 6/9/1998
Binding: Paperback
Pages: 952
Size: 6.75" wide x 9.25" long x 1.75" tall
Weight: 2.992
Language: English

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Charles Dye is the database architect for Excite, Inc. (www.excite.com), where he is responsible for the design and implementation of the databases theat supply content to some of the world's busiest Web sites. Prior to joining Excite, he was the senior database administrator for The Dialog Corporation. Charles also operates a small but growing consultancy with clients in the San Francisco Bay area and Hong Kong. Once upon a time, before fleeing the East Coast for California skies, Charles taught math and physics at the Georgetown Day School in Washington DC. Charles is a frequent speaker at regional and national Oracle events such as Oracle Open World and IOUG-A Live. His favorite topics…    

John Beresniewicz is currently a product analyst at Savant Corporation (www.savant-corp.com) responsible for design and development of the Q Diagnostic Center for Oracle. Prior to joining Savant, he was an Oracle DBA with eight years experience in large corporate client-server environments. Developing the Q product's server-side PL/SQL engine has given John extensive and unique experience with using Oracle built-in packages to develop large package-based applications. John is also known in the Oracle user community as a frequent speaker on DBA and PL/SQL topics and an active participant in various Oracle online discussion groups. He has given papers at numerous IOUW, ECO, and local Oracle…    

Preface
Overview
Introduction
The Power of Built-in Packages
Built-in Packages Covered in This Book
Using Built-in Packages
Examining Built-in Package Source Code
Application Development Packages
Executing Dynamic SQL and PL/SQL
Examples of Dynamic SQL
Getting Started with DBMS_SQL
The DBMS_SQL Interface
Tips on Using Dynamic SQL
DBMS_SQL Examples
Intersession Communication
DBMS_PIPE: Communicating Between Sessions
DBMS_ALERT: Broadcasting Alerts to Users
User Lock and Transaction Management
DBMS_LOCK: Creating and Managing Resource Locks
DBMS_TRANSACTION: Interfacing to SQL Transaction Statements
Oracle Advanced Queuing
Oracle AQ Concepts
Getting Started with Oracle AQ
Oracle AQ Nonprogram Elements
DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)
DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
Oracle AQ Database Objects
Oracle AQ Examples
Generating Output from PL/SQL Programs
DBMS_OUTPUT: Displaying Output
UTL_FILE: Reading and Writing Server-side Files
Defining an Application Profile
Getting Started with DBMS_APPLICATION_INFO
DBMS_APPLICATION_INFO Interface
DBMS_APPLICATION_INFO Examples
Managing Large Objects
Getting Started with DBMS_LOB
LOB Concepts
DBMS_LOB Interface
Datatype Packages
DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only)
UTL_RAW: Manipulating Raw Data
UTL_REF: Referencing Objects (Oracle 8.1 Only)
Miscellaneous Packages
DBMS_UTILITY: Performing Miscellaneous Operations
DBMS_DESCRIBE: Describing PL/SQL Program Headers
DBMS_DDL: Compiling and Analyzing Objects
DBMS_RANDOM: Generating Random Numbers (Oracle8 Only)
Server Management Packages
Managing Session Information
DBMS_SESSION: Managing Session Information
DBMS_SYSTEM: Setting Events for Debugging
Managing Server Resources
DBMS_SPACE: Obtaining Space Information
DBMS_SHARED_POOL: Pinning Objects
Job Scheduling in the Database
Getting Started with DBMS_ JOB
Job Queue Architecture
Tips on Using DBMS_JOB
DBMS_JOB Examples
Distributed Database Packages
Snapshots
DBMS_SNAPSHOT: Managing Snapshots
DBMS_REFRESH: Managing Snapshot Groups
DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation
DBMS_REPCAT: Managing Snapshot Replication Groups
Advanced Replication
DBMS_REPCAT_AUTH: Setting Up Administrative Accounts
DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts
DBMS_REPCAT: Replication Environment Administration
DBMS_OFFLINE_OG: Performing Site Instantiation
DBMS_RECTIFIER_DIFF: Comparing Replicated Tables
DBMS_REPUTIL: Enabling and Disabling Replication
Conflict Resolution
Getting Started with DBMS_REPCAT
Column Groups with DBMS_REPCAT
Priority Groups with DBMS_REPCAT
Site Priority Groups with DBMS_REPCAT
Assigning Resolution Methods with DBMS_REPCAT
Monitoring Conflict Resolution with DBMS_REPCAT
Deferred Transactions and Remote Procedure Calls
About Deferred Transactions and RPCs
DBMS_DEFER_SYS: Managing Deferred Transactions
DBMS_DEFER: Building Deferred Calls
DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance A
What's on the Companion Disk?
Index