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


> 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

Original text of this message