O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

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

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. ...

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