I know this has been answered to some degree with PHP and MYSQL, but I was wondering if someone could teach me the simplest approach to splitting a string (comma delimited) into multiple rows in Oracle 10g (preferably) and 11g.
The table is as follows:
Name | Project | Error 108 test Err1, Err2, Err3 109 test2 Err1
I want to create the following:
Name | Project | Error 108 Test Err1 108 Test Err2 108 Test Err3 109 Test2 Err1
I've seen a few potential solutions around stack, however they only accounted for a single column (being the comma delimited string). Any help would be greatly appreciated.