Oracle update

2個資料表間的更新
UPDATE T1 P
SET col1=
(SELECT col1 FROM T2 S WHERE P.col2 = S.col2)
-----------------------

UPDATE phone p
SET address =
(SELECT address FROM addr a WHERE p.address = address)