Suppression of NULL records?

patch

Member³
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?!?
 
It looks like NULL rows aren't displayed in the command window. Both of the following give the same result:

Code:
select null from dual where 1=1;
select null from dual where 1=2;
 
Back
Top