How to split string variable

From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 25 Nov 2011 08:34:20 -0200

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


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

Follow-Ups:
- Re: How to split string variable
  - From: Radoulov, Dimitre
- Re: How to split string variable
  - From: Norman Dunbar

Other related posts:

» How to split string variable - Eriovaldo Andrietta
» Re: How to split string variable- Radoulov, Dimitre
» Re: How to split string variable- Stephane Faroult
» Re: How to split string variable- Norman Dunbar
» Re: How to split string variable- Norman Dunbar
» Re: How to split string variable- Eriovaldo Andrietta