I have attached my query here. when I can executing from plsql developer , it hardly takes 2 secs.
but when putting in a ref cursor and executing through test window.
It is taking 10 secs to get results to from cursor handle in test window of plsql developer.
Experts, please help.