Re: Can Cursors be combined?

Not that I can think of. But then again I can't think of any reason to ask the question you are asking. How long does it take to cut and paste the two pieces of code together?

And aren't you planning on using EXPLAIN PLAN to see what you are doing?

Daniel Morgan

Chris Smith wrote:

> Suppose I have two functions
>
> FUNCTION get_cur_A RETURN MyCursorType;
> FUNCTION get_cur_B RETURN MyCursorType;
>
> They return the same kind of Cursor but use different Select
> statements Stmt_A and Stmt_B.
>
> Now, I want to have the UNION of the two cursors above.
> I.e. the UNION of the Select statements Stmt_A and Stmt_B.
>
> Is there any way to achieve that without using the statements
> directly?
>
> Thx, Chris.
Received on Thu Mar 14 2002 - 10:53:34 CST