Convert comma separated string to array in PL/SQL

oracle plsql tokenize
Suvonkar picture Suvonkar · Sep 29, 2010 · Viewed 185.2k times · Source

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

Richard Sylvester picture Richard Sylvester · Jan 27, 2015

here is another easier option

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

Related questions

Splitting string into multiple rows in Oracle

I know this has been answered to some degree with PHP and MYSQL, but I was wondering if someone could teach me the simplest approach to splitting a string (comma delimited) into multiple rows in Oracle 10g (preferably) and 11g. …

Read More
Is there a function to split a string in PL/SQL?

I need to write a procedure to normalize a record that have multiple tokens concatenated by one char. I need to obtain these tokens splitting the string and insert each one as a new record in a table. Does Oracle …

Read More
Splitting comma separated string in a PL/SQL stored proc

I've CSV string 100.01,200.02,300.03 which I need to pass to a PL/SQL stored procedure in Oracle. Inside the proc,I need to insert these values in a Number column in the table. For this, I got a working approach from …

Read More