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