O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required