tailieunhanh - Oracle Built−in Packages- P106

Oracle Built−in Packages- P106: 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 Example Here is an example of a call to RANDOM to obtain a random number DECLARE my_random BINARY_INTEGER BEGIN my_random The procedure Oracle8 only When you are done with DBMS_RANDOM you should terminate the program. This will release any memory used by the package. PROCEDURE The TERMINATE procedure does not assert a purity level with the RESTRICT_REFERENCES pragma. Here is an example of a call to terminate the DBMS_RANDOM package SQL exec PREVIOUS HOME NEXT DBMS_DDL Compiling and Analyzing Objects BOOK INDEX III. Server Management Packages . 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 Or de8i features Packages wrrti Packages Introduction Packet Reference Pocket Referenc Copyright c 2000 O Reilly Associates. All rights reserved. DBMS_RANDOM Interface 516 Oracle Built-in Packages SEARCH PREVIOUS Chapter 11 NEXT 517 11. Managing Session Information Contents DBMS_SESSION Managing Session Information DBMS_System Setting Events for Debugging Oracle technologies allow for a great deal of user customization and security. Language preferences can be specified at the session level using the NLS National Language Support options of the ALTER SESSION command. Roles can be used to distinguish groups of users from each other and to modify application behavior accordingly. This chapter describes the following two packages that allow you to perform these operations DBMSSESSION Contains programs that can modify and inspect session roles and settings from within PL SQL. This package also contains programs for manipulating session memory and package states even if they aren t used very often these programs are very instructive to understand. .