Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select to_number(column_value) as IDs from xmltable('1,2,3,4,12.33,testtest');
ORA-19228: XPST0008 - undeclared identifier: prefix '.', local-name ''

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

IDS

1

2

3

4

12.33

select to_number(column_value) as IDs from xmltable('1,2,3,4,12.33,"testtest"');
ORA-01722: unable to convert string value containing 't' to a number: 

select column_value as IDs from xmltable('1,2,3,4,12.33,"testtest"');

IDS

1

2

3

4

12.33

testtest