Re: Question to SQLPLUS gurus
From: Christopher Jones <cjones_at_au.oracle.com>
Date: 1995/06/07
Message-ID: <x7u4a2kclt.fsf_at_hurrah.au.oracle.com>#1/1
Date: 1995/06/07
Message-ID: <x7u4a2kclt.fsf_at_hurrah.au.oracle.com>#1/1
> From: smohamma_at_pms870.pms.ford.com (Shahabuddin Mohammad)
> Newsgroups: comp.databases.oracle
> Date: 25 May 1995 14:56:20 GMT
> 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
> My question : Is there anyway to display 'Total Volumes' in stead of
> 'sum' in the report.
> Is it possible in SQLPLUS?
Yes, with SQL*Plus 3.2 or later.
BREAK ON ctgy SKIP PAGE COMPUTE SUM LABEL "Total Volumes" of vol ON ctgy
Regards,
Chris Received on Wed Jun 07 1995 - 00:00:00 CEST