hntangch1的博客

原创 oracle update

 update a set a.col1 = (select b.col1  from b  where b.col2 = a.col2) where exists (select * from b where a.col2 = b.col2) /**oracle与sqlserver更新update的用法有不同，oracle是怎么处理的呢update a set a.col1=100    ...