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