将一个表与另一个表中数据匹配的全部导入的oracle语句：
update zd_polygon a set(zdzl,ydxm,sfydc,sfsc,tdmj,tdzh,ssgldw,xh,mj,yy ,sfbg ,bz,fmj)=
(select zdzl,ydxm,sfydc,sfsc,tdmj,tdzh,ssgldw,xh,mj,yy ,sfbg ,bz,fmj from zdzl n
where n.layer=a.layer and n.bs=a.bs and n.bs='1') where
exists(select * from zdzl n where n.layer=a.layer and n.bs=a.bs and n.bs='1')