Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(12345 67, 099,999 99) (4)

SQL> Select TO_CHAR(12345.67, '099,999.99')   from dual; TO_CHAR(123 -----------  012,345.67 SQL>