Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can I use a pl/sql cursor as subquery or in another cursor?
May be you could try to use views...
"Peter Mutsaers" <plm_at_gmx.li> schreef in bericht
news:873cqcm3vd.fsf_at_muon.mutsaers.com...
> Is it possible (in oracle 9i) to somehow use a cursor as subquery or
> in another cursor, in order to reuse parts of queries or to build
> complex queries modularly without resorting to dynamic sql?
>
> I thought maybe oracle 9i new pipelined functions or cursor() operator
> might provide something, but I couldn't really figure out how.
>
> I'd like something like this (in a package):
>
> cursor abc(p1 in varchar2) is select a,b,c from tababc where d = p1;
>
> cursor sumabc(p1 in varchar2) is
> select a,sum(c) from (abc(p1)) group by a;
>
>
> It really drives me mad (being used to other computer languages where
> you can build using bottom-up or top-down breakdown) that I don't know
> how to avoid copying blocks of SQL for such cases. It must be possible
> in some way (I hope) to modularize sql statements???
>
>
> --
> Peter Mutsaers, Dübendorf, Switzerland.
Received on Fri Nov 08 2002 - 15:00:14 CST