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

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 - 10:08:35 CST