Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(12345 67, L99,999 99)

SQL> Select TO_CHAR(12345.67, 'L99,999.99')   from dual; TO_CHAR(12345.67,'L9 --------------------           $12,345.67