Re: cursor in side cursor

  • From: "LiShan Cheng" <exriscer@xxxxxxxxx>
  • To: mssql_2002@xxxxxxxxx
  • Date: Tue, 18 Apr 2006 09:24:01 +0200

hi do you mean something like this?

for i in (select * from dept)
loop
    for x in (select * from emp where deptno = i.deptno)
    loop
        ......
    end loop;
end loop;




On 4/18/06, Bob Robert <mssql_2002@xxxxxxxxx> wrote:
>
> Gurus,
>
> Is it posssible to write cursor in side of another cursor?
>
> Thanks,
> Bob
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: