Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Splitting a string using Regular Expressions and table cast multiset

767233Aug 17 2010 — edited Aug 18 2010
Hi there,

I asked a similar question in the past, but can somebody help me with this?

I have a a couple of fields that look like this:

col A
-------
dfd223/aaa333
fffs233/aaa2d2-dfa343/dfe3f3
asdf234/sdafd1234-dfadf234/dfa12 - asdf34/daf233

and I want to make it into something like this:

col a | col b
------------------
dfd223 | aaa333
fffs233| aaa2d2
dfa343 | dfe3f3
asdf234 | sdafd1234
dfadf234 | dfa12
asdf23 | daf233

Can somebody give me a solution and small tutorial on how to do this via regular expressions and hierarchical queries. I tried browsing through tutorials online but it's really really confusing me so if somebody can use this as an example to help me but would be REALLY appreciated. Running Oracle 11gr1 as well, if that matters...

Thanks! =)

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 15 2010
Added on Aug 17 2010
4 comments
1,357 views