DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Compute in SQL*Plus

  1. 03-13-2003, 10:48 AM #1
    aph
    aph is offline Senior Member
    Join Date
    Jul 2001
    Posts
    334

    Compute in SQL*Plus

    Hi
    Using 'COMPUTE SUM OF INV_TOTAL ON REPORT', it print the output like the below line.

    ******** --------
    sum 500.00


    What and where I can change if I want the output according to the below line.

    ******** ------
    Total Of Invoice 500.00


    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 03-13-2003, 10:51 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    COMPUTE SUM LABEL xyz OF INV_TOTAL ON REPORT

    HTH

    http://download-west.oracle.com/docs...h4.htm#1001871
    Last edited by jovery; 03-13-2003 at 10:55 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 03-13-2003, 11:35 AM #3
    aph
    aph is offline Senior Member
    Join Date
    Jul 2001
    Posts
    334
    Thank you so much, it works great!..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width