regexp_split_to_table
- From: jo <jose.soares@xxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jan 2013 07:41:29 +0100
Hi all,
I need to find in Oracle a function similar to Postgres
regexp_split_to_table function
to split values from a text column into a list of numeric values as in:
select * from po;
id | val
----+----------------------
1 | 1,2,3,4,5,6,7,8,9,10
(1 row)
select cast(regexp_split_to_table(val, ',') as int) as numbers from po;
numbers
----------------------
1
2
3
4
5
6
7
8
9
10
(10 rows)
Is there a simple way to do this thing in Oracle?
Thanks for any help.
j
--
//www.freelists.org/webpage/oracle-l
Other related posts:
