在plsql比较Oracle中表是否一致,还要把不一致的字段列出来SQL怎么写,Oracle10G

发布网友发布时间：2022-05-05 18:40

共2个回答

热心网友时间：2022-05-05 20:09

把两个表的相同字段union all 一下，
然后在group by ，数量大于2的是重复的，取数量是1的就行追问SQL怎么写？

追答select *
  from (select *
          from (select 1 as v_num
                  from al
                union all
                select 2 as v_num
                  from al
                union all
                select 3 as v_num
                  from al
                union all
                select 4 as v_num
                  from al
                union all
                select 5 as v_num from al) a
        union all
        select *
          from (select 3 as v_num
                  from al
                union all
                select 4 as v_num
                  from al
                union all
                select 5 as v_num
                  from al
                union all
                select 6 as v_num
                  from al
                union all
                select 7 as v_num from al) b)
group by v_num
having count(1) = 1