Cursors in database management systems

(John Charles Olamendy) This article is intended to show the principles and uses of cursors in relational database management systems. We're going to discuss how cursors are implemented in Microsoft SQL Server and Oracle database and how you can use it in your applications. I want to explain that this is another technique for data retrieval, and I recommend using cursors as the last option for querying your data because they consume a lot of memory, lock resources, and create excessive amounts of code, thus it's better to use SQL statements because is a lower-cost set-based language.

Read More >>