用很多个id查一张表,要 显示id对应的数据
比如前台传一个字符串 1,2,3,4,5 都是id.而且是一张表的.我分割之后如何在一张表内查出这些id对应的数据
[解决办法]
create table t_x (name varchar2(10));
insert into t_x values('001');
insert into t_x values('002');
insert into t_x values('003');
insert into t_x values('004');
insert into t_x values('005');
commit;
select t.*
from t_x t,
(select regexp_substr('001,002,003,004', '[^,]+', 1, level) str
from dual
connect by level <= regexp_count('001,002,003,004', ',') + 1) t1
where t.name = t1.str
