Needs Function - Mailing list pgsql-sql

I need a user defined function for the following purpose….

If I pass a string with comma ( , ) separated chars/values…. It should be appear in next line…

Ex: select get_sep_str (‘SK, rp, h, j, 6, 9, kl’) from dual;

Output :

SK

rp

h

j

6

9

kl

(Or)

I have one table like this…..

Temp Table:

Deptno number(10)

Empno  varchar2(200);

Data in temp table:

Deptno                       Empno

-----------                      ------------

10                                      B3091,B3092,B3093,B3085

11                                      3651,6521

12                                      H3062

Now, I want to display the data like this…..

Deptno                       Empno

---------                        ---------

10                   B3091

10                   B3092

10                   B3093

10                   B3094

11                   3651

11                   6521

12                   H3062

Now, how can I achieve this….