如果是10gR1以上的版本,可以考虑使用
MERGE INTO a
USING b
ON (a.id=b.userid)
WHEN MATCHED THEN UPDATE SET pwd = b.password;
转载于:https://www.cnblogs.com/xsmhero/archive/2011/08/18/2144804.html
转载于:https://www.cnblogs.com/xsmhero/archive/2011/08/18/2144804.html