SQL>
SQL>
SQL> select 123
2 , to_char(123)
3 , to_char(123,'$09999.99')
4 , to_number('123')
5 from dual;
123 TO_ TO_CHAR(12 TO_NUMBER('123')
---------- --- ---------- ----------------
123 123 $00123.00 123
SQL>