I think the second case is an infinite loop. I think oracle always evaluates the right hand side of the where clause first and this sysdate will always be a few milli seconds earlier than the sysdate on the left side.
But in the first case both the sysdates have the same value substituted before the loop starts.




Reply With Quote