Using NVL function on Date column
Please explain the behavior of Oracle when treating empty string and null for DATE datatype.
For example:
create table delete_me1(x number, b date);
insert into delete_me1 values (1, to_timestamp('11/11/2011 22:29:59.999','DD/MM/YYYY HH24:MI:SS.FF3'));
insert into delete_me1 values(1,to_date('11/11/2011 22:29:59','DD/MM/YYYY HH24:MI:SS'));
insert into delete_me1 values(1,to_date('11/11/2011','DD/MM/YYYY'));
select count(1)
from delete_me1 a
where nvl('',b)=b;
COUNT(1)
--------
1
select count(1)
from delete_me1 a
where nvl(null,b)=b;
COUNT(1)
--------
3
Thanks in advance.
Rehab