카테고리 없음
oracle to_char to_number
een
2020. 5. 18. 17:33
SELECT TO_CHAR(1234.56, '0,000.00') FROM dual; -- 1,234.56
SELECT TO_NUMBER(REPLACE('1,234.56', ',', '')) FROM dual;--1234.56