Convert comma separated string to array in PL/SQL April 30, 2023 by Tarik here is another easier option select to_number(column_value) as IDs from xmltable('1,2,3,4,5');