I think he is asking for this: select dname, cursor(select ename from emp where emp.deptno=dept.deptno) from dept; which returns a cursor within a cursor. Richard Ji On 4/18/06, LiShan Cheng <exriscer@xxxxxxxxx> wrote: > hi do you mean something like this? > > for i in (select * from dept) > loop > for x in (select * from emp where deptno = i.deptno) -- //www.freelists.org/webpage/oracle-l