select ID2_DTS from rsm_datasource_xl
where id2_dts in
(select ''''||replace(substr(dts_rule,1,length(dts_rule)-1),',',''',''')||'''' from rsm_dsrule where id_rule = '73')select ''''||replace(substr(dts_rule,1,length(dts_rule)-1),',',''',''')||'''' from rsm_dsrule where id_rule = '73' 是有值的 结果:'010101','010102','010103'但第一个语句执行没结果。为什么??
where id2_dts in
(select ''''||replace(substr(dts_rule,1,length(dts_rule)-1),',',''',''')||'''' from rsm_dsrule where id_rule = '73')select ''''||replace(substr(dts_rule,1,length(dts_rule)-1),',',''',''')||'''' from rsm_dsrule where id_rule = '73' 是有值的 结果:'010101','010102','010103'但第一个语句执行没结果。为什么??
--一般這樣寫
select * from 你的表 where instr(','||'你的列的值'||',',','||'你要搜索的值'||',')>0;
--如
select * from dual where instr(','||'1,2'||',',','||'1'||',')>0;