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 条件的并集

转载于:https://www.cnblogs.com/xsdf/p/8336031.html