Hi,
I have a requirement to split a string which can be of variable length and populate into the same row of a table where the parent string exists.
| ID1 | ID2
| String
| Value1
| Value2
| value3
| value4
| ......
|
|---|
| 1001 | 2001 | 1111#2222#3333 | <should have 1111> | <should have 2222> | <should have 3333> | NULL | NULL |
| 1001 | 2002 | 555#77 | <should have 555> | <should have 77> | NULL | NULL | NULL |
| 1001 | 2003 | 88888#33#1119#777#5644 | <should have 88888> | <should have 33> | <should have 1119> | <should have 777> | <should have 5644> |
I do not want to use PLSQL, Can this be done through SQL..
Any suggestions are appreciated..!!