Oracle SQL :Data Type of NULL

Q)What is the Data Type of NULL?


Ans)

Oracle treats NULL as character value of length of 0.

So, the default data type of NULL is a character data type and to prove it, Created a view on a null column with an alias anull


create view xxview
as
select null anull from dual;


describe xxview;


The describe command shows that the column a has a data type of anull varchar2(0).