SQL & PL/SQL

Hello Friends ,

I have a table called serialnumber with column listvalues that has comma separeted values

example

select listvalues from serialnumber ;

lisvalues
----------------
dfdfd,fdfds,dfdfdf,erere,erere,erere,erere,
dsfsdf
dfsfsd,dfsfs,sdfsfs,fdsfs,dfsfsd


I want to convert each listvalues to rows for example for first row of the output ..


listvalues
---------------
dfdfd
fdfds
dfdfdf
erere
erere
erere
erere


I know we have to use UNPIVOT but could not able to use to implemnet.

thanks/kumar