Re: regexp_split_to_table
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: jose.soares@xxxxxxxxxxxxxx
- Date: Wed, 23 Jan 2013 15:51:57 +0200
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@xxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
