oracle - select in string list argument. from https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

tokenize_string.sql

SELECT  *
FROM    table a
WHERE   A.column_name IN (
            SELECT REGEXP_SUBSTR('1,2,3','[^,]+',  level) FROM dual
            CONNECT BY REGEXP_SUBSTR('1,2,3', '[^,]+',  level) is not null
        )