query output format

[Tee]

How do I format this output to be more readable?

ELECT SUM(amt) "Total"

FROM table_name where type = 'DR' and acct_no ='11122929292';
Total
----------
2.9645E+11

[rmgirma]

Try this:

SELECT TO_CHAR(SUM(amt),'999,999,999,999,990.00')
FROM table_name where type = 'DR' and acct_no ='11122929292';