Is there a setting I am missing that suppresses records with just NULL values?
Check this script:
prompt This shows 3 records
with data as (select null c1, null c2 from dual union all
select 1 , null from dual union all
select null , 2 from dual union all
select 1 , 2 from dual
)
select *
from data
/
prompt This shows 4 records
with data as (select null c1, null c2 from dual union all
select 1 , null from dual union all
select null , 2 from dual union all
select 1 , 2 from dual
)
select nvl(c1, -1) c1
, nvl(c2, -1) c2
from data
/
Or have I stumbled upon a bug?!?