We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,596,021.03 | Books Available: 785,711 | Members Online: 246

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

Search - Oracle Built in Packages

Oracle Built in Packages
Author: Steven Feuerstein, Charles Dye, John Beresniewicz

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather ... more »limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality.Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:

DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.
DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.
DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database.
DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs.

The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book.Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides point-and-click access to the many files of source code and online documentation developed by the authors.The table of contents follows:PrefacePart I: Overview

1. Introduction

Part II: Application Development Packages

Executing Dynamic SQL and PL/SQL
Intersession Communication
User Lock and Transaction Management
Oracle Advanced Queuing
Generating Output from PL/SQL Programs
Defining an Application Profile
Managing Large Objects
Datatype Packages
Miscellaneous Packages

Part III: Server Management Packages

Managing Session Information
Managing Server Resources
Job Scheduling in the Database

Part IV: Distributed Database Packages

Snapshots
Advanced Replication
Conflict Resolution
Deferred Transactions and Remote Procedure Calls

Appendix. What's on the companion disk?

ISBN-13: 9781565923751
ISBN-10: 1565923758
Publication Date: 5/15/1998
Pages: 931
Rating:

0 stars, based on 0 rating

Publisher: O'Reilly
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Computers & Technology >> Databases & Big Data >> Database Management Systems
Computers & Technology >> Databases & Big Data >> Other Databases >> SQL >> General
Computers & Technology >> Databases & Big Data >> Other Databases >> Oracle >> General
Computers & Technology >> Databases & Big Data >> General

Back to the Top ↑

Search - Oracle Built in Packages

Loading...