TO_CHAR, number conversion Syntax TO_CHAR(n [, fmt [, 'nlsparams'] ])
Purpose Converts n of NUMBER datatype to a value of VARCHAR2 datatype, using the optional number format fmt. If you omit fmt, n is converted to a VARCHAR2 value exactly long enough to hold its significant digits. For information on number formats, see "Format Models".
Syntax
TO_CHAR(n [, fmt [, 'nlsparams'] ])
Purpose
Converts n of NUMBER datatype to a value of VARCHAR2 datatype, using the optional number format fmt. If you omit fmt, n is converted to a VARCHAR2 value exactly long enough to hold its significant digits. For information on number formats, see "Format Models".