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