query output format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: query output format

  1. #1
    Join Date
    Feb 2001
    Posts
    32

    query output format

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    Try this:

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width