【Question】
SalesCode TeamBelow
CD0001    a,b,c
CD0002    h,i,j

To:

SalesCode TeamBelow
CD0001 a
CD0001 b
CD0001 c
CD0002 h
CD0002 i
CD0002 j

【Answer】
For the time being, database products can’t handle this type of computing task without lengthy and roundabout code. So I choose to do it in SPL (Structure Process Language):

esPrc provides JDBC interface to function like a database. To learn more, you can refer to How to Call an SPL Script in Java.