Posted on 2009-01-20 15:14
Neil's NoteBook 閱讀(677)
評論(0) 編輯 收藏 所屬分類:
ORACLE
update
(
select a.* from da_page a,da_jbxx b, da_pic c
where a.da_id=b.id
and a.pic_id=c.id
and a.ztdm >= '020'
and a.ztdm < '060'
and (a.shbz='0' or a.shbz='R')
and a.jsbz='N'
and b.swjg_dm like '14201%'
)
set jsbz='Y',shr_dm='14201000087'
where 1=1 and rownum <= '10'