with tt as select distinct name type from dba_source where owner ACC_T

1
2
3
4
5
6
7
with tt as (select distinct name, type from dba_source
where
owner='ACC_TMP'
and text like '%decease%')
select * from dba_source ds,tt
where text like '%IS NULL%'
and tt.name=ds.name;