解决方案 »
- 创建存储过程select赋值给游标的问题!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 求oracle 过程,大数据量处理方法
- 在线!急!急!!同一行显示 主表主键和子表主键(子表主键有多个)
- Oracle数据库都用什么管理?PL/SQL Dev工具版本是否要跟Oracle版本对应?
- 如何识别网络包是否为oracle数据包
- oracle触发器绑定变量
- 用户可不可不安装Oracle客户端
- 一个简单的查询语句的问题,想不出来,请大家赐教
- 怎样查看某个sequence的定义??
- 用oracle 写一个金额大小写转换的函数
- 菜鸟求助:为何使用自定义函数之后查询效率变的非常低?
- 查询嵌套表问题,如何展开嵌套表内容?
SET T1.FY = (SELECT DECODE(SUM(FY), NULL, T1.FY, SUM(FY))
FROM T1 T2
WHERE T2.ID <> T1.ID
AND CONNECT_BY_ISLEAF = 1
START WITH T2.ID = T1.ID
CONNECT BY PRIOR T2.ID = T2.PAR_ID);
SELECT T1.*,
(SELECT DECODE(SUM(FY), NULL, T1.FY, SUM(FY))
FROM T1 T2
WHERE CONNECT_BY_ISLEAF = 1
START WITH T2.ID = T1.ID
CONNECT BY PRIOR T2.ID = T2.PAR_ID) SUMFY
FROM T1
SET T1.FY = (SELECT DECODE(SUM(FY), NULL, T1.FY, SUM(FY))
FROM T1 T2
WHERE T2.ID <> T1.ID
AND CONNECT_BY_ISLEAF = 1
START WITH T2.ID = T1.ID
CONNECT BY PRIOR T2.ID = T2.PAR_ID);
真的是佩服呀,不好想