Comments for Short-Circuit Evaluation in PL/SQL
|Short-Circuit Evaluation in PL/SQL - This article describes how short-circuit evaluation can be used to improve the performance of some boolean expressions.|
Cesc said...ON THE EXPLANATION THERE ARE MISSING THE ASSERTIONS:
TRUE OR NULL = TRUE (Short-Circuit Evaluation of OR)
FALSE AND NULL = FALSE (Short-Circuit Evaluation of AND)
Quite correct. I've added in the NULL related assertions.
I don't think it is necessary to alter the examples as they kind-of prove the point. :)