Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(12345 67, 99999 99) (2)

SQL> SQL> Select TO_CHAR(12345.67, '99999.99') from dual; TO_CHAR(1 ---------  12345.67