Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.arcor-online.net!fu-berlin.de!uni-berlin.de!212.28.39.6!not-for-mail From: Matthias Rogel Newsgroups: comp.databases.oracle.server Subject: Re: can I use a pl/sql cursor as subquery or in another cursor? Date: Mon, 11 Nov 2002 07:44:38 +0100 Lines: 43 Message-ID: References: <873cqcm3vd.fsf@muon.mutsaers.com> <3dcc262a$0$10860$8fcfb86b@news.wanadoo.nl> NNTP-Posting-Host: 212.28.39.6 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Trace: fu-berlin.de 1036997078 12228187 212.28.39.6 (16 [86071]) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en Xref: newsfeed1.easynews.com comp.databases.oracle.server:166541 X-Received-Date: Sun, 10 Nov 2002 23:44:24 MST (news.easynews.com) Well, I think, the problems with views is that there isn't a thing like parameterized views. I hope with Peter, that somedays, there will ... (@ least in Oracle) Matthias Robbert Van der Hoorn wrote: > May be you could try to use views... > > > "Peter Mutsaers" schreef in bericht > news:873cqcm3vd.fsf@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. > > >