oracle比较查询结果

返回在第一个查询结果中与第二个查询结果不相同的那部分行记录。　

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;