Mega Code Archive
Categories
/
Oracle PLSQL
/
Data Type
TO_CHAR(12345 67, 099,999 99)
SQL> SQL> SQL> SELECT TO_CHAR(12345.67, '099,999.99') FROM dual; TO_CHAR(123 ----------- 012,345.67 SQL> SQL>