Click to See Complete Forum and Search --> : Compute in SQL*Plus


aph
03-13-2003, 09:48 AM
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.

jovery
03-13-2003, 09:51 AM
COMPUTE SUM LABEL xyz OF INV_TOTAL ON REPORT

HTH

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/ch4.htm#1001871

aph
03-13-2003, 10:35 AM
Thank you so much, it works great!..