Execution sequence of and, or, not in Oracle where statement

And, or, not:

1. a and B (sequential execution)

(1) true if a and B are the same as true,

(2) a, B, and false are false,

[1] If expression a is false, there is no need to judge later. The entire expression must be false;

[2] if a is true, the subsequent judgment is made. If B is true, the expression is true. If B is false, the entire expression is false;

2. a or B (sequential execution)

(1) true for a and B

[1] if a is true, there is no need to judge it. The expression is true;

[2] if a is false, continue to judge B. If B is false, the expression is false. If B is true, the expression is true;

(2) If a and B are the same as false, the expression returns false.

In this case, a is false, and B is also false;

3. not a (execute a first and obtain the inverse)

Invert

A-> true, not a-> false;

A-> false, not a-> true;