DELETE Clause
An optional DELETE WHERE clause can be used to clean up after a merge operation. Only those rows which match both the ON clause and the DELETE WHERE clause are deleted.
MERGE INTO test1 a
USING all_objects b
ON (a.object_id = b.object_id)
WHEN MATCHED THEN
UPDATE SET a.status = b.status
WHEREb.status != 'VALID'
DELETE WHERE (b.status = 'VALID');
这句delete部分怎么理解?试了几次 delete 部分没测试成功
[ 本帖最后由 paulyibinyi 于 2008-8-12 17:06 编辑 ]