Oracle 11g provides a number of built-in functions for working with character strings, dates, and numbers. It also provides you with datatype conversion functions. This appendix covers these functions as well as functions for both object reference and error management. Last, it includes a miscellaneous section. These functions initialize large objects, perform advanced comparisons, and audit system environment variables.
Alphabetically indexed, the built-in functions are organized by type. Only a subset of all functions is listed in this appendix. These should be the more frequently used functions in your programs. Small example programs demonstrate how to use the built-in functions in PL/SQL: