Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(-12345 67, 99,999 99PR)

SQL> Select TO_CHAR(-12345.67, '99,999.99PR')   from dual; TO_CHAR(-12 ----------- <12,345.67>