Oracle Cumulative SUM analysis function sum over the use of ___ static function

Example 1:select deptno,ename,job,sal,sum (SAL) over (order by Sal) his from EMP; Results: SMITH Clerk JAMES Clerk 950 1750 ADAMS Clerk 1100 2850 WARD salesman 1250 5350 MARTIN salesman 1250 5350 MILLER Clerk 1300 6650 TURNER salesman 1500 8150 ALLEN salesman 1600 9750 example 2:select deptno,ename,sal, SUM (SAL) over (partition by the Deptno order by ename) his from EMP; Result: CLARK 2450 2450 KING 5000 7450 MILLER 1300 8750 ADAMS 1100 1100 FORD 3000 4100 JONES 2975 7075 SC OTT 3000 10075 SMITH 10875 ALLEN 1600 1600 BLAKE 2850 4450