If i want to join (scan) 1000 tables to get the output then how to do this scenario in plsql or sql .this is interview question
Printable View
If i want to join (scan) 1000 tables to get the output then how to do this scenario in plsql or sql .this is interview question
try to break the join into multiple set . and then using the concept of cursor prepare the reasonalble set of data to work and go ahead with the nested cursor. this will help you for the performation as well as it won't take the internal memory.