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_at_gmail.com> 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