Oracle Built−in Packages- P165: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Examining Built-in Package Source Code booh index 2. Executing Dynamic SQL and PL SQL . Orode PL SQL Orode PL SQL Orode Advonced PL SQL Orode Wei Applications Grade PL SQL Grade PL SQL ory I Programming I Programming I Buit in I Programming I PL SQL Developer s I Language I Bait-ins MW Second Edition Guide to Ornde8i Features Packages wrdi Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. Part II Application Development Packages 811 Oracle Built-in Packages SEARCH PREVIOUS Part III NEXT 812 Part III Server Management Packages This part of the book describes the built-in server management packages Chapter 11 Managing Session Information introduces you to DBMS_SESSION and DBMS_SYSTEM these two packages help you analyze and manage information about your current session. Chapter 12 Managing Server Resources presents DBMS_SPACE and DBMS_SHARED_POOL which contain handy tools for database administrators to help them manage database-related resources on the server. Chapter 13 Job Scheduling in the Database shows you how to use DBMS_JOB to schedule the execution of stored procedures without the use of operating sytem-specific schedulers such as UNIX s cron. PREVIOUS DBMS_RANDOM Generating Random Numbers Oracle8 Only HOME BOOK INDEX NEXT 11. Managing Session Information . Oracle PL SQL Oracle PL SQL Oracle Advanced PL SQL Oracle Wei Applications Oracle PL SQL Oracle PL SQL I Programming I Programming I Budt-in I Programming I PL SQL Developer s I Language I Budt-ins MM Second Edition Guide to OrocleBi Features Packages wrtii Packages Introduction Packet Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. Part III Server Management Packages .
