select owner, table_name, reason, '12.1', 121
from "_DBA_STREAMS_UNSUPPORTED_11_2" o
where not exists
(select 1 from "_DBA_STREAMS_UNSUPPORTED_12_1" i
where i.owner = o.owner
and i.table_name = o.table_name)
SELECT OWNER
, TABLE_NAME
, REASON
, '12.1'
, 121
FROM "_DBA_STREAMS_UNSUPPORTED_11_2" O
WHERE NOT EXISTS
(SELECT 1
FROM "_DBA_STREAMS_UNSUPPORTED_12_1" I
WHERE I.OWNER = O.OWNER
AND I.TABLE_NAME = O.TABLE_NAME)
|
|
|