Re: Can Cursors be combined?

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3C90D58F.B70AC3E6_at_exesolutions.com>...
> 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?

1. avoiding code duplication in order to increase maintainability and error-proofness of my PL/SQL code.
2. making maximal use of the cursors already loaded from DB.
3. hiding the implementation of the sub-queries (this argument might be a little bit academic).

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

You are right, working with cursors in this way might result in suboptimal SQL code. Nevertheless, if the two cursors are already loaded from DB, it seems to me the best strategie to paste their results together (instead of pasting SQL code). Received on Fri Mar 15 2002 - 02:09:45 CST