How does Oracle perform an OR check?

Question

In Java, the logical condition OR behaves such that if the first condition true, then it does not evaluate the second condition.

For example:

int a = 10;
if (a == 10 || a == 0) {
    // Logic
}

Java does not evaluate the second test ( a == 0) as the first condition ( a == 10) true.

If we have an Oracle SQL statement:

select * from student where city = :city and 
    (:age is null or age > :age)

How are graded (age > :age or :age is null)? If the parameter :ageis equal NULL, then it also evaluates the second condition?

Answer 1

PL / SQL

In PL / SQL, Oracle OR is another example of short circuit assessment. Oracle PL / SQL Fundamentals Speaks (Partially)

Short circuit rating

PL/SQL . PL/SQL , . , .

SQL

SQL OR . @JonHeller , , , 0.

Answer 2

. , . , , . SQL , .

"", , , .

Answer 3

Oracle . . , null .

:age is null or age > :age

age > nvl(:age, age - 1)