Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(0012345 6700, FM99999 99)

SQL> Select TO_CHAR(0012345.6700, 'FM99999.99')   from dual; TO_CHAR(0 --------- 12345.67