oracle 字符串分割

Question

输入sql语句中传入参数：‘2020,2030‘怎样分割成’2020,‘，2030’用in查询

Answer 1

--这种一般用instr就可以了，例：
SQL> with t(id) as(
  2  select 2020 from dual
  3  union select 2030 from dual
  4  union select 2040 from dual
  5  )
  6  select * from t where instr(','||'2020,2030'||',',','||id||',')>0;        ID                                                                      
----------                                                                      
      2020                                                                      
      2030