熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle中whereclause的表達式的順序

2013-11-13 16:01:02  來源: Oracle 

  今天調試半天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
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.