Oracle Built-in Packages
Home > Computing and Information Technology > Databases > Database software > Oracle Built-in Packages
Oracle Built-in Packages

Oracle Built-in Packages


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Oracle's built-in packages extend the power of the PL/SQL language in significant ways. This volume offers a comprehensive reference to all of Oracle's built-in packages, including the new packages available with Oracle 8. The diskette includes a tool that provides easy access to the many files of source code and documentation developed by the authors.

Table of Contents:
Preface. I. Overview. 1. Introduction The Power of Built-in Packages Built-in Packages Covered in This Book Using Built-in Packages Examining Built-in Package Source Code. II. Application Development Packages. 2. 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. 3. Intersession Communication DBMS_PIPE: Communicating Between Sessions DBMS_ALERT: Broadcasting Alerts to Users. 4. User Lock and Transaction Management DBMS_LOCK: Creating and Managing Resource Locks DBMS_TRANSACTION: Interfacing to SQL Transaction Statements. 5. 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. 6. Generating Output from PL/SQL Programs DBMS_OUTPUT: Displaying Output UTL_FILE: Reading and Writing Server-side Files. 7. Defining an Application Profile Getting Started with DBMS_APPLICATION_INFO DBMS_APPLICATION_INFO Interface DBMS_APPLICATION_INFO Examples. 8. Managing Large Objects Getting Started with DBMS_LOB LOB Concepts DBMS_LOB Interface. 9. Datatype Packages DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only) UTL_RAW: Manipulating Raw Data UTL_REF: Referencing Objects (Oracle8.1 Only). 10. 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). III. Server Management Packages. 11. Managing Session Information DBMS_SESSION: Managing Session Information DBMS_SYSTEM: Setting Events for Debugging. 12. Managing Server Resources DBMS_SPACE: Obtaining Space Information DBMS_SHARED_POOL: Pinning Objects. 13. Job Scheduling in the Database Getting Started with DBMS_ JOB Job Queue Architecture Tips on Using DBMS_JOB DBMS_JOB Examples IV. Distributed Database Packages. 14. Snapshots DBMS_SNAPSHOT: Managing Snapshots DBMS_REFRESH: Managing Snapshot Groups DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation DBMS_REPCAT: Managing Snapshot Replication Groups. 15. 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. 16. 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. 17. 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

About the Author :
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is also the author of Oracle PL/SQL Programming (O'Reilly & Associates, Second Edition, 1997) and Advanced Oracle PL/SQL Programming with Packages (O'Reilly & Associates, 1996). Steven has been developing software since 1980 and worked for Oracle Corporation from 1987 to 1992. He is a partner with RevealNet, Inc. (www.revealnet.com) and is the chief architect of the RevealNet products, PL/SQL Knowledge Base and PL/Vision (a code library of prebuilt PL/SQL packages which accelerates PL/SQL-based application development). Steven also sysops RevealNet's "PL/SQL Pipeline," an online community for PL/SQL developers (www.revealnet.com/plsql-pipeline). He can be reached through email at feuerstein@revealnet.com. Steven is also president of PL/Solutions, which offers training and consulting on both PL/Vision and PL/SQL (www.plsolutions.com). Finally (on the Oracle side of Steven's life), he serves as codirector of the Oracle Practice at SSC, a systems management consulting firm based in Chicago (www.saraswati.com).


Best Sellers


Product Details
  • ISBN-13: 9781565923751
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Language: English
  • Returnable: 00
  • ISBN-10: 1565923758
  • Publisher Date: 09 Jun 1998
  • Binding: Book
  • No of Pages: 900
  • Returnable: N


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle Built-in Packages
O'Reilly Media -
Oracle Built-in Packages
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle Built-in Packages

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!