Total Pageviews

December 20, 2017

12/20/2017 12:40:00 PM
Q)What is the Data Type of NULL?


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
select null anull from dual;

describe xxview;

The describe command shows that the column a has a data type of anull varchar2(0).
Related Posts Plugin for WordPress, Blogger...