Ebook: Oracle PL/SQL Built-Ins Pocket Reference

This companion quick reference to Steven Feuerstein's bestselling Oracle PL/SQL Programming and Oracle Built-in Packages will help you use Oracle's extensive set of built-in functions and packages, including those new to Oracle8. Built-in functions offer the most essential and commonly used operations for PL/SQL development; SUBSTR, TO_DATE, and ADD_MONTHS are just a few of the dozens of functions covered here. Built-in packages greatly expand the capabilities of the PL/SQL language. DBMS_SQL, for example, executes dynamically constructed queries, DDL statements, and even PL/SQL blocks. In addition to DBMS_SQL, this book covers DBMS_PIPE, DBMS_LOB, UTL_FILE, and many more. This easy-to-access reference shows how to call each of the built-in functions and packaged programs and how to identify those programs that can be executed from within an SQL statement. The authors also supplement the calling syntax with the exceptions, constants, and data structures defined in the packages.