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>
1
002
3
04
xyz
5
777
67
000
11
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-lReceived on Fri Nov 25 2011 - 04:58:31 CST