oracle比较查询结果

wo936968op

返回在第一个查询结果中与第二个查询结果不相同的那部分行记录。　
SELECT mg.ex_code,
mg.inst_class,
mg.issue_type,
mg.ex_source_code
FROM mod_group     mg,
exchange_list exl
WHERE mg.exl_id = exl.exl_id
AND exl.exl_name = 'BUCHSE_EQB_XMBS'
MINUS
SELECT mg.ex_code,
mg.inst_class,
mg.issue_type,
mg.ex_source_code
FROM mod_group     mg,
exchange_list exl
WHERE mg.exl_id = exl.exl_id
AND exl.exl_name = :out_sExlName;


返回查询结果中相同的部分　　
SELECT mg.ex_code,
mg.inst_class,
mg.issue_type,
mg.ex_source_code
FROM mod_group     mg,
exchange_list exl
WHERE mg.exl_id = exl.exl_id
AND exl.exl_name = 'BUCHSE_EQB_XMBS'
intersect
SELECT mg.ex_code,
mg.inst_class,
mg.issue_type,
mg.ex_source_code
FROM mod_group     mg,
exchange_list exl
WHERE mg.exl_id = exl.exl_id
AND exl.exl_name = :out_sExlName;