SELECT TO_CHAR(1234.56, '0,000.00') FROM dual; --  1,234.56
SELECT TO_NUMBER(REPLACE('1,234.56', ',', '')) FROM dual;--1234.56