Oracle Built-In Packages [With *]
Lieferbar innert 2 Wochen
BeschreibungOracle'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.
InhaltsverzeichnisPreface. 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
PortraitSteven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). He has also published his first book for kids: http://stevenfeuerstein.com/vivianvulture. Steven currently serves as PL/SQL Evangelist for Oracle Corporation. He has been developing software since 1980, spent five years with Oracle (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014. He was an Oracle ACE Director (had to give up the prestigious title when he rejoined Oracle) and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Steven's latest initiative is the PL/SQL Challenge ( http://www.plsqlchallenge.com ), a daily quiz for PL/SQL developers; hundreds of programmers play each day. Check it out and join the fun! You can also catch up on his latest, mostly non-PLSQL rants at http://feuerthoughts.blogspot.com.
Untertitel: 3. 5 DISK. Sprache: Englisch.
Verlag: O'REILLY & ASSOC INC
Erscheinungsdatum: Mai 1998
Seitenanzahl: 956 Seiten