How to use a comma-delimited set of plsql stored procedures in Oracle (comma-delimited string to a collection)

Original:

Https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

' Smith,allen,ward,jones ' is a collection of 4 values, and what needs to be handled in the stored procedure in order to achieve the effect of in (value 1, value 2, value 3, value 4);

The following methods are useful for reference: The following method is implemented by turning a comma-expression into a column of 4 rows of the collection.

Select Regexp_substr (' Smith,allen,ward,jones ', ' [^,]+ ', 1, level] from dual
Connect by Regexp_substr (' Smith,allen,ward,jones ', ' [^,]+ ', 1, level) are NOT NULL

How to use a comma-delimited set of plsql stored procedures in Oracle (comma-delimited string to a collection)