Formidable Tips About How To Avoid Using Cursors

I dont like both approaches.

How to avoid using cursors. When you are hadling large volume of data then better to use bulk. You absolutely do not need a cursor for this. What to use instead of cursor and in what cases to do so?

It improves performance by minimizing context switches sql and pl/sql. Hi all, i have a huge database and i am using cursor to retrieve data and with each fatched data i m doing some operation.as my database is increasing the time duration to. Unless you are willing to duplicate the code in the xref proc, there is no way to avoid using a cursor.

Cursors are horrible for performance as you obviously realize. C) this strategy does not seem very flexible. Just use subquery in for clause ex:for emprec in (select * from emp) loop dbms_output.put_line(emprec.empno);

No exit statement needed implicit. Report table has a list of products and all the entitlements which use the products. Write sql statements instead of cursors if action applied to rows is same.

February 28, 2014 at 8:34 am. You can use bulk binding to avoid cursors. Hi all, i have a huge database and i am using cursor to retrieve data and with each fatched data i m doing some operation.as my database is increasing the time duration to execute the cycle.

Rewrite cursors as a derived query. We can help you but first. There are quite a lot of tasks set up with this dynamic sql/cursor.