Re: Can two cursors be joined?

From: Josue Batista <jbatista_at_abcsolutions.org>
Date: Sat, 10 Jul 1999 20:37:05 -0400
Message-ID: <7m8os2$8p0$1@nntp5.atl.mindspring.net>

Assuming that the two cursors contain two datasets with related information, you might want to consider creating one cursor instead of two. When creating that cursor, place the apropriate SQL logic to join the two datasets, may be using UNION, INTERCEPT and/or MINUS.

Hope that helps.
--
Josue Batista
ABC Tech Solutions
http://www.abcsolutions.org
[Java/Oracle/Linux] [C/S & Internet Database Apps]

Mark Reichman wrote in message <37862945.2F39CDE0_at_rl.af.mil>...
>I have two cursors full of data. I would like to
>join the cursors if possible. I would rather not make two
>temp tables and then join the temp tables.
>Any ideas?
Received on Sat Jul 10 1999 - 19:37:05 CDT