oracle表有3个column A B C现在查询where条件,必须A B C同时满足一组条件, 并且这些条件可能会有很多组。比如where (A = 'A1' AND B = 'B1' AND C= 'C1')
OR (A = 'A2' AND B = 'B2' AND C= 'C2')
OR (A = 'A3' AND B = 'B3' AND C= 'C3')就是这样的条件,有没有更好的写法呢?谢谢大家
OR (A = 'A2' AND B = 'B2' AND C= 'C2')
OR (A = 'A3' AND B = 'B3' AND C= 'C3')就是这样的条件,有没有更好的写法呢?谢谢大家
(('A1','B1','C1'),('A2','B2','C2'))可替换成select语句