Oracle a Parameter with multi value

Note: Both solutions are limited by the parameter length of oracle internal character functions by 4000.
IN addition, for personal tests, the performance is not as high as the overall running speed of "inserting data into a physical table and then JOIN queries" or "performing IN queries every 1000 IDs.

 

Create or replace procedure tables (v_id_list in varchar2, v_cursor out sys_refcursor) isbegin open v_cursor select * from THE (select cast (in_list (v_id_list) as -- select cast (in_list ('abc, xyz, 012 ') as mytableType) from dual) a; open v_cursor select * from T1 (select cast (in_list (v_id_list) as -- select cast (in_list ('abc, xyz, 012 ') as mytableType) from dual) t2 where t1. ID = t2.COLUMN _ VALUE); end p_getData_byMultiValue; http://asktom.oracle.com/pls/asktom/f? P = 100: 11: 0: P11_QUESTION_ID: 210612357425