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'
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
Navicate 如何导出数据库中的存储过程、事件、视图等?
每日一记:Oracle升级2020年4月份的数据库补丁Database Patch Set Update : 11.2.0.4.200414 (30670774)
网友评论