Suppression of NULL records? - Allround Automations forums

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?!?

Both variants show me 4 records.
13.0.6.1911
Oracle 12.2.0.1.0

Oops! I have mistaken. You're right: in Command window - 3 records for the 1st query.

Yep, it seems to be 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;

This does indeed not seem quite right. We'll fix it.