oracle - Convert comma separated string to array in PL/SQL

Question

How do I convert a comma separated string to a array?

I have the input '1,2,3' , and I need to convert it into an array.

Answer 1

here is another easier option

select to_number(column_value) as IDs from xmltable('1,2,3,4,5');