Oracle中whereclause的表達式的順序

　　今天調試半天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

From:http://tw.wingwit.com/Article/program/Oracle/201311/17675.html