Re: cursor in side cursor

  • From: "Richard Ji" <richard.c.ji@xxxxxxxxx>
  • To: exriscer@xxxxxxxxx
  • Date: Tue, 18 Apr 2006 12:42:08 -0400

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: