Need help in using pl/sql CURSOR
498297Jun 19 2006 — edited Jun 20 2006Hi
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