TO_CHAR (number) - Oracle Help Center
TO_CHAR (number) Syntax to_char_number::= Description of the illustration to_char_number.gif Purpose TO_CHAR (number) converts n to a value of VARCHAR2 datatype, using the optional number format fmt. The value n can be of type NUMBER, BINARY ......