示例：
UPDATE A
SET A.c2 =B.c3
from A ,B
where A.c1=B.c1
from A inner join B on A.c1=B.c1
本文轉自 netcorner 部落格園部落格，原文連結：http://www.cnblogs.com/netcorner/archive/2013/02/16/2913445.html ，如需轉載請自行聯系原作者
示例：
UPDATE A
SET A.c2 =B.c3
from A ,B
where A.c1=B.c1
from A inner join B on A.c1=B.c1
本文轉自 netcorner 部落格園部落格，原文連結：http://www.cnblogs.com/netcorner/archive/2013/02/16/2913445.html ，如需轉載請自行聯系原作者
![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)