<div>
<div class="content wysiwyg-content">
I have amount . I need that amount to be comma separated numbers. <br />
For example 10000 = 10,000. How to do that query in oracle.<br />
<br />
See my query here: <br />
select sum(violation_Amount) as TotAmount from tab1 where Month_Name = 'JAN' and year_name = '2012'<br />
<br />
Just update this query please.<br />
<br />
Regards<br />
Shaji
</div>
</div>


I have amount . I need that amount to be comma separated numbers. 
For example 10000 = 10,000. How to do that query in oracle.

See my query here: 
select sum(violation_Amount) as TotAmount from tab1 where Month_Name = 'JAN' and year_name = '2012'

Just update this query please.

Regards
Shaji

Convert numbers to comma separated numbers in oracle query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.