-与上面类似
DELETE FROM test WHERE object_id IN (
SELECT/*+driving_site(v_remote.a)*/ object_id FROM v_remote WHERE object_id IN (
SELECT c.object_id FROM c WHERE c.object_name IN (SELECT d.object_name FROM d WHERE d.object_id=11)
));
--远程表操作,自动driving_site(remote)
INSERT INTO xm@remote( object_name,object_id,object_type)
SELECT * FROM v_remote WHERE object_id IN (
SELECT c.object_id FROM c WHERE c.object_name IN (SELECT d.object_name FROM d WHERE d.object_id=11)
看看官网demo中的table