Comma Separated Values

I need deptno and against/beside it comma separated ename's for join dept.deptno=emp.deptno in a single query.

I require deptno=10 against/beside ename=scott,blake,richard,moxon like this.

can u try this ?

select * from dept,emp where dept.deptno = emp.deptno and emp.ename in ('scott','blake','richard','moxon')