oracle 10g IN子句查询
请忽略下面明显的语法缺陷：
我有一个像这样的SQL作为命名查询：
select saalry from emp where emp_id in (:id)
String id = 121,123,456
ORA-01722: invalid number
没有找到相关结果
已邀请:
2 个回复
扭湘阀柿蹄
是一个包含相对较短的逗号分隔数字列表的字符串（例如），这对您来说可能就足够了：select saalry from emp where INSTR( ',' || :id || ',' , ',' || TRIM(TO_CHAR(emp_id)) || ',' ) > 0;上使用索引。物崎巩
select regexp_substr('SMITH,ALLEN,WARD,JONES','[^,]+', 1, level) from dual connect by regexp_substr('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, level) is not null;select * from emp where ename in ( select regexp_substr('SMITH,ALLEN,WARD,JONES','[^,]+', 1, level) from dual connect by regexp_substr('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, level) is not null );