Oracle PL/SQL Built-ins Pocket Reference

John Beresniewicz, Chip Dawes, Steven Feuerstein9781565924567, 1565924568

This pocket reference provides quick-reference information that will help you use Oracle Corporation’s extensive set of built-in functions and packages, including those new to Oracle8.Oracle’s PL/SQL language is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Among the most useful constructs in the PL/SQL language are the built-in functions and packages.Built-in functions are constructs that operate on certain types of data (e.g., numeric, character) to return a result. By using functions, you can minimize the coding you need to do in your programs. Functions are described in detail in Steven Feuerstein’s Oracle PL/SQL Programming; this comprehensive guide to building applications with PL/SQL has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality.

---

Table of contents :
Table of Contents……Page 2
1.1 Introduction……Page 5
1.2 Conventions……Page 6
1.3.1 DBMS_ALERT……Page 7
1.3.2 DBMS_APPLICATION_INFO……Page 8
1.3.4 DBMS_AQADM……Page 9
1.3.5 DBMS_DDL……Page 11
1.3.7 DBMS_JOB……Page 12
1.3.8 DBMS_LOB……Page 13
1.3.9 DBMS_LOCK……Page 16
1.3.10 DBMS_OUTPUT……Page 17
1.3.11 DBMS_PIPE……Page 18
1.3.12 DBMS_RANDOM……Page 19
1.3.13 DBMS_ROWID……Page 20
1.3.14 DBMS_SESSION……Page 22
1.3.16 DBMS_SPACE……Page 23
1.3.17 DBMS_SQL……Page 24
1.3.19 DBMS_SYSTEM……Page 30
1.3.20 DBMS_TRANSACTION……Page 31
1.3.21 DBMS_UTILITY……Page 32
1.3.22 UTL_FILE……Page 36
1.3.23 UTL_RAW……Page 37
1.3.24 UTL_REF……Page 39
1.4.1 Character Functions……Page 41
1.4.2 Numeric Functions……Page 44
1.4.3 Date Functions……Page 45
1.4.4 Conversion Functions……Page 46
1.4.6 Miscellaneous Functions……Page 47
1.5 RESTRICT REFERENCES Pragmas……Page 50
1.6.3 DBMS_AQ……Page 55
1.6.6 DBMS_LOB……Page 56
1.6.11 DBMS_SQL……Page 57
1.6.14 UTL_FILE……Page 58
1.6.15 STANDARD……Page 59