How To Use Format Number with Commas SQL Oracle

Posted on by

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

Posted in SQL.