oracle in or 区别

or与in一样的案例

a in (1,2,3)
(a = 1 or a = 2 or a = 3)
  • 1
  • 2

or与in不一样的案例

a = 1 && b = 2 or a = 3
相当于
(a = 1 && b =2 ) 与 a = 3 条件的并集
posted @ 2018-01-23 15:25  *蓄势待发*  阅读(767)  评论(0编辑  收藏  举报