Re: cursor in side cursor

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)
--
http://www.freelists.org/webpage/oracle-l


Other related posts: