Evaluating both sides of OR?

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 16 Apr 2009 16:52:50 +0300
Message-id: <49E73832.9070900_at_inter.net.il>

I seem to remember that oracle is evaluating both sides of OR in where clause.

select a,b from c where a =1 and (:v1 is null or function(:v1) = b);

Is the function activated when :v1 is null?


Adar Yechiel
Rechovot, Israel


http://www.freelists.org/webpage/oracle-l Received on Thu Apr 16 2009 - 08:52:50 CDT

Original text of this message