I know in C like languages logical operators are evaluated one at a time so:
false && really_expensive_function()
is doesn't result in the function being called (I can't remember the CS name for this). Does the same happen in PL/SQL or do I need to break the IF parts out to separate blocks?