oracle数据库语句积累

update jqhdzt
   set shid =
       (select shid
          from v_plat_userjqinfo t
         where jqhdzt.jqbh = t.JQBH
           and jqhdzt.shid <> t.SHID)
 where shid = ‘0000010047‘
   and exists (select 1
          from v_plat_userjqinfo t
         where jqhdzt.jqbh = t.JQBH
           and jqhdzt.shid <> t.SHID)