if not (i_ReLaunch = 1 and (dt_enddate is not null)) How this epression will be evaluated in Oracle

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:23 UTC
Read the original article Hit count: 136

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 oracle10g

Related posts about database