Select * from
(
select 'MY_USER.DATA' "Row Source", a.* from
(
select /*+ FULL(Tbl1) */
ID, D
from MY_USER.DATA Tbl1
minus
select /*+ FULL(Tbl2) */
ID, D
from MY_USER.DATA1 Tbl2
) A
union all
select 'MY_USER.DATA1', b.* from
(
select /*+ FULL(Tbl2) */
ID, D
from MY_USER.DATA1 Tbl2
minus
select /*+ FULL(Tbl1) */
ID, D
from MY_USER.DATA Tbl1
) B
)
Order by 1 |