How to display number as Hundred separator formator in oracle?

Question

When I'm retrieving number column in oracle getting like this 1237.89 I want to display number column as 1,237.89

How to get this in Oracle.

Answer 1

You could use to_char with the optional format argument:

SELECT TO_CHAR(mycol, '9,999.99')
FROM   mytable