2.4k questions
2.4k answers
99.5k users
It can be done using parameters for csr2 and opening csr2 for each fetch from csr1. But that is not good for performance. Joining can be done between tables in a query or between what is called common-table expressions and/or common-table expressions and tables.
source https://community.oracle.com/tech/developers/discussion/4335674/can-you-join-2-cursors