Oracle Built-in Packages
Publisher: O'Reilly Media
Final Release Date: May 1998
Pages: 956

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 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'sOracle 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?
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyOracle Built-in Packages
 
5.0

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Sort by

Displaying reviews 1-2

Back to top

 
5.0

Essential!

By Columbia Kai.

from Undisclosed

Comments about oreilly Oracle Built-in Packages:

If you're not making regular use of Oracle's many built-in packages you're missing out on some of the great power in Oracle.

This book was an invaluable reference to me while learning Oracle. I only regret it hasn't been updated and re-released.

(0 of 1 customers found this review helpful)

 
5.0

Oracle Built-in Packages Review

By Adrian

from Undisclosed

Comments about oreilly Oracle Built-in Packages:

This book is fantastic... I think that some may find it hard to come to grips with all the possibilities... and then to read, understand and then implement the options. But if they do, they will indeed find out why Steven, Charles, and John took the time to write this... Simply, if a person doesn't come to understand the most powerful and efficacious tools for a PL/SQL developer (that is "Built-In Packages") they and the companies they work for... R' MISSIN' OUT!

I hope they continue to write on the new packages available under 8i and 9i including the UTL_SMTP, and the packages for the web... even despite them being covered under other authors.

Displaying reviews 1-2

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  APK, DAISY, ePub, Mobi
Print & Ebook: $54.95
This item is not available.
Print: $49.95
The shipment of this item may be delayed.