请教一下各位老师，oracle如何实践sqlserver 里面那样更新效果

[MUling123456]

如图上面，sql server可以运用自身的循环更新方式给变量赋值，然后计算更新，求教，oracle怎么实现
运算的效果如下图所示

真心请教一下各位老师

[nayi_224]

with tab1 as (
select 1 ord, 3 qty, 'ce1' stype from dual union all
select 2 ord, 2 qty, 'ce1' from dual union all
select 3 ord, 4 qty, 'ce1' from dual 
)
select t1.*,
       sum(-t1.qty) over(partition by t1.stype order by t1.ord) + 5 nd
  from tab1 t1;

我记得sqlserver里有分析函数啊，怎么搞这么麻烦？