Tuesday, February 18, 2014

Implicit and Explicit cursors in PL/SQL

1. A good article covering implicit and explicit cursors. 

http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#BABCFDJE

2. Downsides to cursors!
The are very slow  :
http://www.sqlteam.com/article/cursors-an-overview

3.  Interesting article on cursor performance

http://www.sqlteam.com/article/cursor-performance

4.SQL Server cursor removal
http://weblogs.sqlteam.com/jeffs/archive/2008/06/05/sql-server-cursor-removal.aspx 

No comments:

Post a Comment