Re: regexp_split_to_table

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Wed, 23 Jan 2013 15:51:57 +0200
Message-ID: <CAMHX9JLFziSNj-XGnxMZ6+gpk_QnZ=TCjkbGGwc2BdXiQdNfwA_at_mail.gmail.com>

In addition to Sayan's examples, there's a CONNECT BY technique here (plus links to more techniques):
http://blog.tanelpoder.com/2007/06/20/my-version-of-sql-string-to-table-tokenizer/

-- 
*Tanel Poder*
Enkitec (The Exadata Experts)
Training <http://blog.tanelpoder.com/seminar/> |
Troubleshooting<http://blog.tanelpoder.com/>
 | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>
 | Voicee App <http://voic.ee/>


On Wed, Jan 23, 2013 at 8:41 AM, jo <jose.soares_at_sferacarta.com> wrote:



> 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

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 23 2013 - 14:51:57 CET