No it doesn't. Select NULL is resulting in one row with a NULL (unknown) value:And what does that show Dummy?Isn't that obvious?
Selecting NULL resulting with one empty row
Just because SQL*Plus by default displays nulls as blanks doesn't mean it is empty. By telling SQL*Plus to display the NULL as something else proves that the output is really a null value.
SQL> select null from dual 2 ; N - SQL> SQL> SQL> SQL> select NULL from dual; N - SQL> select '' from dual; ' - SQL> set NULL NULL SQL> select NULL from dual; N - N U L L SQL> select '' from dual; ' - N U L L