Re: SELECT * FROM (MyCursor Results) ..?

Thanks for the response. There is a special case where I will have to link (join) to a table in an external database. I could just put that in the cursor query, but I don't want to impose that overhead since data from the other table will only be required about 10% of the time. So my idea was to take the cursor results as its own recordset and then do the external link.

I wonder if there is, instead, some parameter I could send to the cursor that could conditionally do the join...

"David Fowler" <dbf57_at_earthlink.net> wrote in message news:7sSj6.2681$6N6.280445_at_newsread2.prod.itd.earthlink.net...
> Brian,
> Try to insert the result set of first cursor output in temp table (If
> your on Oracle 8i). See manual on transaction/session type table.
>
> Is there a join column between them ? or are they completely unrelated
> things (Cartian product then if joined) . The second query will have to
> work off the table/views.
> hth,
> Dave Fowler
>
> "Brian Y." <NOSP_at_M> wrote in message
> news:Fq%i6.42$MX.226054_at_news2.news.adelphia.net...
> > Is it possible to use the results of a cursor inside a query - similar
 to
> > the way I would do a nested query? So I have a cursor in my DECLARE
 area...
> >
> > CURSOR c1 IS SELECT f1, f2 FROM table1...
> >
> > and further down I'm working in another query. I know I could do
 something
> > like
> >
> > SELECT f1 FROM (SELECT f1, f2 FROM table1... ),
> >
> > that's standard. But is there any way to pull the cursor results into
 the
> > query, as in...
> >
> > SELECT f1 FROM (c1...)?
> >
> > Or maybe there's another syntax, structure or approach that I should be
> > using? The problem is I have a global query (in a cursor) that I really
> > can't change, but I need to link to another table from it. Any thoughts?
> > Thanks.
> >
> > B~
> >
> >
> >
>
>
Received on Sun Feb 18 2001 - 11:46:57 CST