今天调试半天where clause里面到底先执行什么where A OR B AND C居然先执行B AND C! 顿时觉得对SQL知道太少！那么复杂的都写出来但是这个基本的这个不知道于是googling原来如下
Expression in where clause process in following order:
Arithmetic Operators
Concatenation operators
Comparison Conditions
IS [NOT] NULL LIKE [NOT] IN
来源() Oracle中where clause的表达式的顺序_sillylily_新浪博客
[NOT] BETWEEN
Not Equal To
NOT Logical Condition
AND Logical Condition
OR Logical Condition
