Oracle Built in Packages Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle Built in Packages? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle Built in Packages. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle Built in Packages ReviewIf you want to take advantage of Oracle's Built-in packages (and you should, if you're doing anything with PL/SQL), this book is a lifesaver. After struggling to follow Oracle's documentation regarding Dynamic SQL in PL/SQL procedures, I spent a few days with this book and was able to understand and utilize the DBMS_SQL package to create some powerful PL/SQL stored procedures. The book (like most of O'Reilly's books) is well-written, and has great examples--something sorely lacking in Oracle's documentation. This and Mr. Feuerstein's other book on PL/SQL "Oracle PL/SQL Programming" are great resources. Look at the O'Reilly Oracle series before you buy similar Oracle Press books.Oracle Built in Packages Overview
Oracle is the most popular database management system in use today, andPL/SQL plays a pivotal role in current and projected Oracle products andapplications. PL/SQL is a programming language providing proceduralextensions to the SQL relational database language and to an ever-growingnumber 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 steptowards becoming a fully realized programming language providingsophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to buildingapplications with PL/SQL. That book has become the bible for PL/SQLdevelopers who have raved about its completeness, readability, andpracticality.

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 onOracle's built-in packages. but there is much more to say about the basicPL/SQL packages than Feuerstein could fit in his first book. In addition,now that Oracle8 has been released, there are many new Oracle8 built-inpackages not described in the PL/SQL book. There are also packages extensionsfor specific oracle environments such as distributed database. hence this book.

Oracle Built-in Packages pulls together information about how to use thecalling 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 providespoint-and-click access to the many files of source code and onlinedocumentation developed by the authors.

The table of contents follows:

Preface

Part 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 InformationManaging Server ResourcesJob Scheduling in the Database

Part IV: Distributed Database Packages
SnapshotsAdvanced ReplicationConflict ResolutionDeferred Transactions and Remote Procedure Calls
Appendix. What's on the companion disk?

Want to learn more information about Oracle Built in Packages?

>> Click Here to See All Customer Reviews & Ratings Now