How To Use Format Number with Commas SQL Oracle
You can use format number with commas or 1000 separator in oracle sql
SELECT to_char(1000,’9,999.00′, ‘NLS_NUMERIC_CHARACTERS = ”,.”’) FROM DUAL
You can use format number with commas or 1000 separator in oracle sql
SELECT to_char(1000,’9,999.00′, ‘NLS_NUMERIC_CHARACTERS = ”,.”’) FROM DUAL