Re: Question to SQLPLUS gurus
Date: 1995/05/26
Message-ID: <D95woA.6KM_at_eskimo.com>#1/1
If you are on Unix platform and you are spooling the report to a file, you can use "sed" to replace "sum" with other labels. You can put the "select" and all the SQLPLUS stuff into a script file and then add "sed" after the SQLPLUS.
Have fun,
Kim
Shahabuddin Mohammad (smohamma_at_pms870.pms.ford.com) wrote:
: Hi,
: I have a SQLPLUS report that uses the following statement
: to get the sum of volumes.
: BREAK ON ctgy SKIP PAGE
: COMPUTE sum of vol ON ctgy
: In the report I get the following:
: ************************
: sum 8404600
: My question : Is there anyway to display 'Total Volumes' in stead of
: 'sum' in the report.
: I wish I see the report like:
: ************************
: Total Volumes 8404600
: Is it possible in SQLPLUS?
: Thanks ahead for the solution.
: - Shabu.
Received on Fri May 26 1995 - 00:00:00 CEST