Evaluating both sides of OR?

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Apr 2009 16:52:50 +0300

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

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2009