The cursor is the main feature that allows the application developer to move the entire context to the row level. From my point of view, when teaching application developers to work in the database, I would completely remove the cursor from their work agenda and forbid the use of it until they learn and understand the concept of the data set. I would also remove the loop feature from their development activity and not allow them to loop under any circumstances. Cursors with loops are the favorite tools of many application programmers, who like to use them often because ...
© Stefan Ardeleanu 2016
Stefan Ardeleanu, Relational Database Programming, 10.1007/978-1-4842-2080-1_6
6. The Challenge of Scalar Functions
Stefan Ardeleanu1
(1)Bucharest, Romania
Get Relational Database Programming: A Set-Oriented Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.