APPENDIX JPL/SQL Built-in Functions

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:

Character

Get Oracle Database 11g PL/SQL Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.