my table structure is given bellow
deptid ename
10 CLARK,KING,MILLER
20 ADAMS,FORD,JONES,SCOTT,SMITH
but i want the output sould be like
10 CLARK
KING
MILLER
------------------
20 ADAMS
FORD
JONES
SCOTT
SMITH
please tell me how to do it in sql