How Oracle 10g evaluates NULL in boolean expressions
Posted
by Phani Kumar PV
on Stack Overflow
See other posts from Stack Overflow
or by Phani Kumar PV
Published on 2010-04-22T15:13:57Z
Indexed on
2010/04/22
15:53 UTC
Read the original article
Hit count: 297
if not (i_ReLaunch = 1 and (dt_enddate is not null))
How this epression will be evaluated in Oracle 10g
when the input value of the i_ReLaunch = null
and the value of the dt_enddate
is not null
it is entering the loop.
According to the rules in normal c# and all it should not enter the loop as
it will be as follows with the values.
If( not(false and (true))
= if not( false)
=if( true)
which implies it should enters the loop
But it is not happening
Can someone let me know if i am wrong at any place
© Stack Overflow or respective owner