image

CHAPTER11Conversion 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:

image 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 string literals must be enclosed in single quotation marks:

NUMBER includes just the digits 0 through 9, a decimal point, and a minus sign, if necessary. ...

Get Oracle Database 12c The Complete Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.