update #SP_GL_BAL_T set (BEG_DR_AMT,BEG_CR_AMT) =
( select A.BEG_DR_AMT,A.BEG_CR_AMT
from #SP_GL_BAL_T a
where #SP_GL_BAL_T.RECLEVEL=0 AND A.RECLEVEL=-1
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9
)
where exists ( select 1 from #SP_GL_BAL_T a
where #SP_GL_BAL_T.RECLEVEL=0 AND A.RECLEVEL=-1
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9 );
( select A.BEG_DR_AMT,A.BEG_CR_AMT
from #SP_GL_BAL_T a
where #SP_GL_BAL_T.RECLEVEL=0 AND A.RECLEVEL=-1
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9
)
where exists ( select 1 from #SP_GL_BAL_T a
where #SP_GL_BAL_T.RECLEVEL=0 AND A.RECLEVEL=-1
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9 );
解决方案 »
- ps/sql 中写存储过程,有没有自动对齐快捷键?
- 谁在LINUX下安装两个不同的DATAGUARD?
- 小弟很菜,望各位高手好心帮助!
- 请问:ORACLE如何在触发器中调用存储过程?
- 大家来研究一下这个存储
- 在存储过程中如何使用变量作表名那?(高手帮助,荡产求)
- 怎样将Date类型的默认格式改成yyyy-mm-dd
- 求教几道备份与恢复试题的答案,在线等
- 这样的SQL语句怎么写
- 希望得到的一个结果集是List<Map<Object,List<Object>>,能否一个SQL采用分组完成呢?
- 怎么编程查询oracle某个用户所拥有的所有的schema对象?(如表,触发器等)
- 此问题持续两周未能得到解决,请兄弟们帮帮我!在下以分相许!
(select BEG_DR_AMT,BEG_CR_AMT
from SP_GL_BAL_T a
A.RECLEVEL=-1
AND A.CODE1=b.CODE1
AND A.CODE2=b.CODE2
AND A.CODE3=b.CODE3
AND A.CODE4=b.CODE4
AND A.CODE5=b.CODE5
AND A.CODE6=b.CODE6
AND A.CODE7=b.CODE7
AND A.CODE8=b.CODE8
AND A.CODE9=b.CODE9)
where b.RECLEVEL=0;