SQL & PL/SQL

Hi all,

My requirement is to display the number in below format.
If it is 123456.67 , it should be displayed as 123,456.67
If it is 123456 , it should be displayed as 123,456 only.

I tried the below options:

select to_char('123456.67','999,999,999,990.99') from dual;
123,456.67

select to_char('123456','999,999,999,990') from dual;
123,457

Is there any way of handling both the scenarios, in a single query ?

Thanks in Advance.

Agathya