Dept No        Dept Name
10             Accounting      
Employee ID    Name       Salary      Sum Salary
7782           CLARK       2450           2450
7934           MILLER      1300           3750
7839           KING        5000           8750
Dept No        Dept Name
20             Research      
Employee ID    Name       Salary      Sum Salary
7369           SMITH       800            800 
7788           SCOTT      3000           3800 
7902           FORD       3000           6800
Dept No        Dept Name
30             Sales      
Employee ID    Name       Salary      Sum Salary
7844          TUNER       1500           1500
7499          ALLEN       1600           3100
7521          WARD        1250           4350
7900          JAMES        950           5300

emp table
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------

 EMPNO                                     NOT NULL NUMBER(4)
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER(4)
 HIREDATE                                           DATE
 SAL                                                NUMBER(7,2)
 COMM                                               NUMBER(7,2)
 DEPTNO                                             NUMBER(2)

dept table

 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------

 DEPTNO                                    NOT NULL NUMBER
 DNAME                                              VARCHAR2(15)
 LOC                                                VARCHAR2(15)

SQL> break on deptno on dname
SQL> select
  2    d.deptno,
  3    d.dname,
  4    e.empno,
  5    e.ename,
  6    e.sal,
  7    sum(e.sal) over (partition by d.deptno order by e.empno) rsal
  8  from emp e,
  9       dept d
 10  where e.deptno = d.deptno
 11  order by d.deptno, e.empno;

    DEPTNO DNAME               EMPNO ENAME             SAL       RSAL
---------- -------------- ---------- ---------- ---------- ----------
        10 ACCOUNTING           7782 CLARK            3250       3250
                                7839 KING             5800       9050
                                7934 MILLER           2100      11150
        20 RESEARCH             7369 SMITH            1600       1600
                                7566 JONES            3775       5375
                                7788 SCOTT            3800       9175
                                7876 ADAMS            1900      11075
                                7902 FORD             3800      14875
        30 SALES                7499 ALLEN            2400       2400
                                7521 WARD             2050       4450
                                7654 MARTIN           2050       6500
                                7698 BLAKE            3650      10150
                                7844 TURNER           2300      12450
                                7900 JAMES            1750      14200

14 rows selected.

SQL>

SQL> set heading off
SQL> col no     format a14
SQL> col name   format a14
SQL> col sal    format a14
SQL> col sumsal format a14
SQL> select case
  2           when grouping(e.empno) = 1
  3             then 'Dept No
  4  '||to_char(e.deptno)||'
  5  Employee Id'
  6             else to_char(e.empno)
  7         end no,
  8         case
  9           when grouping(e.empno) = 1
 10             then 'Dept Name
 11  '||initcap(d.dname)||'
 12  Name' 
 13           else e.ename
 14         end name,
 15         case
 16           when grouping(e.empno) = 1
 17             then '
 18  '||'
 19  Salary'
 20           else to_char(e.sal)
 21         end sal,
 22         case
 23           when grouping(e.empno) = 1
 24             then '
 25  '||'
 26  Sum Salary'
 27           else to_char(sum(e.sal) over (partition by e.deptno order by e.empno))
 28         end sumsal
 29  from emp e, dept d
 30  where d.deptno = e.deptno 
 31  group by rollup ((e.deptno,d.dname),(e.empno,e.ename,e.sal))
 32  having grouping_id(e.deptno,e.empno) != 3
 33  order by e.deptno, grouping(e.empno) desc, empno
 34  /
Dept No        Dept Name
10             Accounting
Employee Id    Name           Salary         Sum Salary
7782           CLARK          2450           2450
7839           KING           5000           7450
7934           MILLER         1300           8750
Dept No        Dept Name
20             Research
Employee Id    Name           Salary         Sum Salary
7369           SMITH          800            800
7566           JONES          2975           3775
7788           SCOTT          3000           6775
7876           ADAMS          1100           7875
7902           FORD           3000           10875
Dept No        Dept Name
30             Sales
Employee Id    Name           Salary         Sum Salary
7499           ALLEN          1600           1600
7521           WARD           1250           2850
7654           MARTIN         1250           4100
7698           BLAKE          2850           6950
7844           TURNER         1500           8450
7900           JAMES          950            9400