August 2002
Intermediate to advanced
528 pages
10h 12m
English
Oracle has included a number of functions that are used to modify alphanumeric data types. These are the character types VARCHAR and CHAR. The functions may be used as expressions in the SELECT clause or as arguments in the WHERE clause. We have seen one of these functions in a previous chapter: The concatenation operator (||) was used to combine several column values and a text literal into a new combined value. This chapter will cover other character functions that are available to perform specialized manipulation of character data.