Split Comma Separated string and pass to IN clause of Select Statement. Split single comma delimited string into rows in Oracle. How to convert comma separated values column to rows in oracle using “regexp” Function

Split Comma Separated string and pass to IN clause of Select Statement.

Split single comma delimited string into rows in Oracle.

How to convert comma separated values column to rows in oracle using “regexp” Function

SELECT  regexp_substr(:P_Range,'[^,]+',1,level) p_range FROM dual

CONNECT BY regexp_substr(:P_Range,'[^,]+',1,level) is not null

ORDER BY 1