Comparing Null with Null in Decode
987536Jan 28 2013 — edited Jan 28 2013Hi all,
I am karthik,
update emp
set ename = decode((select ename from emp where empno = 769),
(select ename from emp where empno = 772),
(select '1' from dual),'F_B')where empno = 7839;
actually both the select statement inside the decode written null.
here both null are equated and updated 1 with emp table. (null=null not possible)
'NULL cannot be equated with anything '
why and what happen here?
Please reply to me
thanks,
karthik m