2.4k questions

2.4k answers

95.6k users

4 Online Users
0 Member 4 Guest
Today Visits : 64
Yesterday Visits : 2184
Total Visits : 2345553



Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc


Viktoria Katsanioti,




0 votes

1 Answer

0 votes

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

by (46.5k points)