示例：
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=)