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

Filed under:
|
|
|
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

Related posts about Oracle

Related posts about oracle10g