CHAPTER 11Conversion and Transformation Functions

This chapter looks at functions that convert, or transform, one datatype into another. Four major datatypes and their associated functions have been covered thus far:

images CHAR (fixed-length character strings) and VARCHAR2 (variable-length character strings) include any letter of the alphabet, any number, and any of the symbols on the keyboard. Character literals must be enclosed in single quotation marks:

    ′Sault Ste. Marie!

images NUMBER includes just the digits 0 through 9, a decimal point, and a minus ...

Get Oracle Database 10g The Complete Reference now with O’Reilly online learning.

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