number format

[lesstjm]

When I query for a sum of a column I am getting the following:
1.1052E+11
How do I get this to come out as $1,105,200.00......?

[pipo]

there are 2 points
1) getting the whole number (not ...E+..) is done by changing the value of the numwidth parameter (set numwidth 20)
2) getting the $, '.', and ',' is done with to_char :
select to_char (column,'$999G999G999D00)
from table;
(with enough 999 of course)