SQLPLUS Tricky Question...Where are the SQL Gurus ??

From: Darryl Snedeker x52168 <dsnedeke>
Date: 1995/08/03
Message-ID: <DCqtM5.ME7_at_txnews.amd.com>#1/1


break on report;
compute sum of salary on report;

select deptno, employee_name, salary
from emp
order by deptno, employee_name;

The above script, as you know, will produce a listing of all employees and will order by department number. For each department, a sum of salaries will be computed. The string 'Sum ' will appear on the same line as each total.

How do I change this string 'Sum' to appear as another literal string. I am fairly certain I have seen this worked out before, but is has been 3-4 years and
I cannot find the notes I once had.

Please don't respond by saying this can't be done, I've already heard from your premier representative.

Any assistance in this matter would be greatly appreciated.

-D

--

Darryl Snedeker 		ph# (512) 602-2168
Senior Database Administrator	fax (512) 602-5018
Advanced Micro Devices		Austin, Texas
Received on Thu Aug 03 1995 - 00:00:00 CEST

Original text of this message