Splitting strings into multiple rows in Oracle 10g

1136755 pts.
Tags:
Oracle 10g
Strings
Would anybody know the easiest way to splitting a string, that's comma delimited, into multiple rows in Oracle 10g and 11g? I have this table:
Name | Project | Error 
108    test      Err1, Err2, Err3
109    test2     Err1
And I need it like this:
Name | Project | Error
108    Test      Err 1
108    Test      Err 2 
108    Test      Err 3 
109    Test2     Err1
Does anyone have an idea? Thank you very much!
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: