Oracle version 11g
Windows XP
I am trying to create a sqlplus report on emp table on which i need subtotals and grand total breaking on "deptno". So I have used
BREAK ON DEPTNO SKIP 1
COMPUTE SUM OF SAL ON DEPTNO
COMPUTE SUM OF SAL ON REPORT
My requirement is I need an extra new line after every subtotal. Can you help me what command or setting to change.?
DEPTNO ENAME SAL
-------------- ---------------- -----------
10 John 1000
Anil 2000
-----------
3000
<extra new line>
20 Foney 300
-----------
300
<extra new line>
------------
3300