根个数没有关系吧!SQL> desc test1;
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
COL1 VARCHAR2(10) Y
COL2 VARCHAR2(10) Y SQL> select * from test1;COL1 COL2
---------- ----------
1 1
2 2SQL> select * from test1 where col1 in('2','3');COL1 COL2
---------- ----------
2 2SQL> select * from test1 where col1 in("2","3");select * from test1 where col1 in("2","3")ORA-00904: "3": 无效的标识符SQL>
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
COL1 VARCHAR2(10) Y
COL2 VARCHAR2(10) Y SQL> select * from test1;COL1 COL2
---------- ----------
1 1
2 2SQL> select * from test1 where col1 in('2','3');COL1 COL2
---------- ----------
2 2SQL> select * from test1 where col1 in("2","3");select * from test1 where col1 in("2","3")ORA-00904: "3": 无效的标识符SQL>
一般你可以新建一个表
将这一千种情况甚至更多都插进去
并且,你还可以在这个表上建索引
然后再用表连接inner join
这样效率会提高
另外,你还可以将表建成临时表