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
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