orcle修改一个表的状态为另一个表中对应的状态

UPDATE cm_serviceattr_instance a
SET a.attrcode = (SELECT b.attrcode
                       FROM pub_serviceattr_def b
                       where a.serviceattrid = b.serviceattrid)
where a.serviceattrid in(select b.serviceattrid from pub_serviceattr_def b);