How to split string variable
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Fri, 25 Nov 2011 08:34:20 -0200
Message-ID: <CAJdDhaPN83zcuqY0kCRGUU5a=mcqsX0_fr_DBGENVE-+B5YsjA_at_mail.gmail.com>
Hi friends,
Date: Fri, 25 Nov 2011 08:34:20 -0200
Message-ID: <CAJdDhaPN83zcuqY0kCRGUU5a=mcqsX0_fr_DBGENVE-+B5YsjA_at_mail.gmail.com>
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-lReceived on Fri Nov 25 2011 - 04:34:20 CST