Why does SQL*Plus split query result?
745509Jan 10 2010 — edited Jan 10 2010My result is:
ENAME DEPTNO SAL RUNNING_TOTAL DEPARTMENT_TOTAL SEQ
---------- ---------- ---------- ------------- ---------------- ----------
CLARK 10 2450 2450 2450 1
KING 10 5000 7450 7450 2
MILLER 10 1300 8750 8750 3
ADAMS 20 1100 9850 1100 1
FORD 20 3000 12850 4100 2
JONES 20 2975 15825 7075 3
SCOTT 20 3000 18825 10075 4
SMITH 20 800 19625 10875 5
ALLEN 30 1600 21225 1600 1
BLAKE 30 2850 24075 4450 2
JAMES 30 950 25025 5400 3
ENAME DEPTNO SAL RUNNING_TOTAL DEPARTMENT_TOTAL SEQ
---------- ---------- ---------- ------------- ---------------- ----------
MARTIN 30 1250 26275 6650 4
TURNER 30 1500 27775 8150 5
WARD 30 1250 29025 9400 6
14 rows selected.
It is very annoying and I wonder if there is a way to tell SQL*Plus not to split this result into 2 sub-results.