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
Printable View
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
Try this:
SELECT TO_CHAR(SUM(amt),'999,999,999,999,990.00')
FROM table_name where type = 'DR' and acct_no ='11122929292';