oracle更新语句，高手来。。。。。。。。。。 ( 积分: 50 )

update m set m.STS='OS_ACT' , m.DEC_DATE = sysdate ,m.dec_staff_code = n.STAFF_CODE,m.DEC_OFR= n.POS_CODE

from dps.de_clf m ,ogc.v_officer n where

m.DEC_STAFF_CODE=n.STAFF_CODE and

m.DEC_OFR=n.POS_CODE and n.username='Action' and

m.clf_no='1'

update dps.de_clf m set
(m.STS,m.DEC_DATE,m.dec_staff_code,m.DEC_OFR)=
(select 'OS_ACT',sysdate,n.STAFF_CODE,n.POS_CODE from ogc.v_officer n
where n.username='Action'
and m.DEC_STAFF_CODE=n.STAFF_CODE
and m.DEC_OFR=n.POS_CODE)
where m.clf_no='1'

接受答案了.