Oracle语句Update、Select用法 Update tableOne set (a,b,c,d,e,f,g) =(select a1,b1,c1,d1,e1,f1,g1 from tableTwowhere f1='20120711' And f2=1) where f3='01'