Re: How to split string variable

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Fri, 25 Nov 2011 11:58:31 +0100
Message-ID: <4ECF74D7.4020902_at_gmail.com>


11:57:50 SQL> r

   1 select
   2 replace('1:002:3:04:xyz:5:777:67:000:11',':', chr(12))    3 from
   4* dual

REPLACE('1:002:3:04:XYZ:5:777:



1
002
3
04
xyz
5
777
67
000
11

Regards
Dimitre

On 25/11/2011 11:34, Eriovaldo Andrietta wrote:
> Hi friends,
>
> I have this:
>
> 1:002:3:04:xyz:5:777:67:000:11
>
> and I want to extract this as result, using sql or regular expression:
>
> 1
> 002
> 3
> 04
> xyz
> 5
> 777
> 67
> 000
> 11
>
> How can I do it ?
>
> Regards
> Eriovaldo
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 25 2011 - 04:58:31 CST

Original text of this message