shwq.net
当前位置:首页 >> orAClE ExCEption 写whEn othErs thEn输出AA!但是... >>

orAClE ExCEption 写whEn othErs thEn输出AA!但是...

源代码 ?

CREATE OR REPLACE TRIGGER trg_A after update of aa ON a referencing new as new old as old for each row declare begin if :new.aa:old.aa then update B set aa=:new.aa where A.XX=B.XX; end if; exception when others then null; end t...

试试这样: update tabxxx set a = (case when a = 'aa' then 'dd' else a end), b = (case when b = 'aa' then 'dd' else b end) where a = 'aa' or b='aa'

select wm_concat(aa) from ( select '今天'||"商品"||'商品销售'||"金额"||'元' aa from table_name );

selectcase when AA.fhid>BB.fhid then AA.fhid else BB.fhid end,case when BB.fhid>AA.fhid then BB.fhid else AA.fhid end,AA.zhid,BB.zhidfrom (select a.fhid ,b.zhid,a.dyfrom t_gg_fwxxfh a,t_gg_fwxxz b,t_mpb cwhere b.zhid =a.zhid an...

select zd.addtionName, case nvl(aa.opertype ,0) when 0 then '未开启' else '已开启' end as status, case nvl(aa.advType ,0) when 1 then '包月' else '按条' end as ifBag, nvl(aa.Fee ,0) as AddFee from advanceAddtion aa ,zdAddtion z...

应该是vs2010里你要执行的sql字符串拼接有问题吧。或者是某个单引号,你把vs2010里这句sql的代码贴出看看。

网站首页 | 网站地图
All rights reserved Powered by www.shwq.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com