ORACLE删除锁死教程,oracle教程
delete from TMP_MZRBB_CZYXMTJ1;
insert into TMP_MZRBB_CZYXMTJ1(sfxmflmc,sfbz,je,wssdm,pxxh,xmfl)
Select b.sfxmflmc
,a.sfbz
,sum(b.je) as je
,b.wssdm
,0 as pxxh
,(select dmz from sys1_code d where d.fldm='1920' and d.xmdm=c.xmlbdm) as xmfl
From mz_sfzb a,mz_sfmx b,UV_BASE_XMXXK C
Where a.id=b.zb_id
-- and a.czrybm=PARM_CZYDM
and a.wssdm=b.wssdm
and a.wssdm=c.wssdm
and b.itemclass =c.xmlbdm
and b.itemcode=c.ypdm
--and isnull(a.cfysid,'') <> ''
Group by b.sfxmflmc,b.wssdm,a.sfbz,c.xmlbdm;
ALTER system kill session '286, 2184'
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。