Oracle语句Update、Select用法

Update tableOne set (a,b,c,d,e,f,g) =
(select a1,b1,c1,d1,e1,f1,g1 from tableTwo
where f1='20120711' And f2=1) where f3='01'