集合操作符 Union / Union All / Intersect / Minus

 集合操作符

Union / UnionAll / Intersect / Minus

-- 生成测试数据create table dept_01 as select * from dept where rownum < 6;create table dept_02 as select * from dept where rownum < 4;insert into dept_02 values (98, '小吃部', '斗门');insert into dept_02 values (99, '外卖部', '香洲');commit;select * from dept_01unionselect * from dept_02;select * from dept_01union allselect * from dept_02;select * from dept_01intersectselect * from dept_02;select * from dept_01minusselect * from dpet_02;