Merge into

测试语句

MERGE /*+ parallel(a 4) */ INTO dayu0322 a
USING dayu0404 b
ON (a.object_id=b.object_id)
WHEN MATCHED THEN
UPDATE set a.object_name='dayu';

 

MERGE INTO dayu0322 a
USING dayu0404 b
ON (a.object_id=b.object_id)
WHEN MATCHED THEN
UPDATE set a.object_name='dayu';

 

 未提交update语句，可以执行shutdown immediate