SQL & PL/SQL

Hello Oracle Guru's

I am having a requirement to parse or spilt names in one field in to separate records based on delimiter (comma). I am giving an example which will explain my requirement.

I am using Oracle 11g. I used regexp_substr function, it is not working

Input (Source Table)

ID                   Name   

100                 John,Smith,willam

200                 A,B,C

300                 X,Y,Z

Output (Target Table)

ID                        Name

100                      John

100                      Smith

100                      William

200                       A

200                       B

200                      C

300                      X

300                      Y

300                      Z

Thanks in advance.