错了,应该是 (table1 union all table2) minus (table1 intersect table2)
... TYPE table_forall IS TABLE OF test_forall%ROWTYPE; v_table table_forall;BEGIN SELECT XXX,XXX BULK COLLECT INTO v_table FROM (SELECT * FROM A MINUS SECT * FROM B); ...
minus是否可以跨表空间或者用户??
UNION 并集 INTERSECT 交集 MINUS 差 UNION ALL全部SELECT * FROM TABLE1 UNION/UNION ALL/INTERSECT/MINUS SELECT * FROM TABLE2 根据需要使用.
(table1 union all table2)
minus
(table1 intersect table2)
TYPE table_forall IS TABLE OF test_forall%ROWTYPE;
v_table table_forall;BEGIN
SELECT XXX,XXX
BULK COLLECT INTO v_table FROM (SELECT * FROM A MINUS SECT * FROM B);
...
INTERSECT 交集
MINUS 差
UNION ALL全部SELECT * FROM TABLE1
UNION/UNION ALL/INTERSECT/MINUS
SELECT * FROM TABLE2
根据需要使用.