We have functions for converting date to char and vice versa.
Do we have any function in oracle which converts number to string?
asked
How to convert number to string ?
The function to_char will do it. Here's an example:
SELECT '$' || to_char (3.14159) FROM dual;
Or you can use CAST, which is in the ANSI Standard:
SELECT cast (3.14159 AS VARCHAR2(20)) FROM dual;
The to_char function allows formatting:
SELECT To_Char(0,'$99,990.00') FROM dual;
And it will convert dates with formatting, too:
SELECT To_Char(current_date,'DDMMYYYY') FROM dual;
