Hello Guys
Help needed on Converting comma separated column values to rows...!
| I've a table like below loaded from csv file into Oracle, I wanted to load the details table like below i.e values in Master.Project should get transformed into rows of Details.project |
| MASTER | | |
| ID | NAME | PROJECT |
| 101 | JOHN | GREEN, BLUE, RED |
| 102 | RAM | RED, WHITE, BLACK |
| | |
| | |
| DETAILS | | |
| ID | NAME | PROJECT |
| 101 | JOHN | GREEN |
| 101 | JOHN | BLUE |
| 102 | RAM | RED |
| 102 | RAM | WHITE |
| 101 | JOHN | RED |
| 102 | RAM | BLACK |
About my SQl exp: i'm not DB guy but uses oracle SQL to write select queries/views to feed my reports.
please suggest/help