Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help in using pl/sql CURSOR

498297Jun 19 2006 — edited Jun 20 2006
Hi

Is there some way to use the results of the cursor in following SELECT statement ?

i want something like following :

Stored Procedure / Function :
-----------------------------
OPEN cursor1 FOR
SELECT .......................;

OPEN cursor2 FOR
SELECT * FROM cursor1 where .................................

Return cursor1 and cursor2;

----------------------------

I hope you understand this. I am stuck at some point for this, so any help will be really appreciated.

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2006
Added on Jun 19 2006
10 comments
396 views