lazy evaluation in query?

[nicchu]

hi, i wonder if oracle uses "lazy/shortcut evaluation" for the where clauses?

like in java expression:

if (A || B)

- evaluates A only if A is true
- evaluates B only if A is false

if (A && B)

- evaluates B only if A is true

--------------------------

select 'X'
from students
where
(last_name != 'A' or
first_name = 'Mark') and
(......... etc.........)

--------------------------
if student name is
first_name = Mark
last_name = B

would statement first_name = 'Mark' get evaluated (and go straight to etc)?
Thanks!

[pando]

I believe it does
if have the book Oracle 8i complete references in the first 25 pages I think it explains about this

[nishant]

Hi,

Yes it does according to Oracle Docs.

Take Care.

[ashishiitm]

yeah it does the same