Datenunterschiede zwischen 2 Tabellen
SQL:
----
Select * from
  (
    select 'LKSADM.LKST_PCRD_DET' Source, a.* from
    (
select /*+ FULL(Tbl1)  */
       PCRL_PCRD_NO, PCRL_PCRD_CRDS_ID, mod_by, SQIP, CRE_BY
from   LKSADM.LKST_PCRD_DET Tbl1
minus
select /*+ FULL(Tbl2)  */
       PCRL_PCRD_NO, PCRL_PCRD_CRDS_ID, mod_by, SQIP, CRE_BY
from   GNEVELI1.LKST_PCRD_DET Tbl2

     ) A
    union all
    select 'GNEVELI1.LKST_PCRD_DET', b.* from
    (
select /*+ FULL(Tbl2)  */
       PCRL_PCRD_NO, PCRL_PCRD_CRDS_ID, mod_by, SQIP, CRE_BY
from   GNEVELI1.LKST_PCRD_DET Tbl2
minus
select /*+ FULL(Tbl1)  */
       PCRL_PCRD_NO, PCRL_PCRD_CRDS_ID, mod_by, SQIP, CRE_BY
from   LKSADM.LKST_PCRD_DET Tbl1

     ) B
  )
Order by  1

Ergebnis:
---------

  
    
GNEVELI1.LKST_PCRD_DET
    
40915010101
    
132
    
PRAU1xx
    
7
    
HCIROTZK
  
  
    
LKSADM.LKST_PCRD_DET
    
40915010101
    
132
    
PRAU1
    
7
    
HCIROTZK