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
Date: 1995/08/03
Message-ID: <DCqtM5.ME7_at_txnews.amd.com>#1/1
break on report;
select deptno, employee_name, salary
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
compute sum of salary on report;
from emp
order by deptno, employee_name;
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, TexasReceived on Thu Aug 03 1995 - 00:00:00 CEST