What is a cursor for loop?

Q

What is a cursor for loop?

✍: Guest

A

A cursor FOR loop is a loop that is associated with (actually defined by) an explicit cursor or a SELECT statement incorporated directly within the loop boundary. Use the cursor FOR loop whenever (and only if) you need to fetch and process each and every record from a cursor, which is a high percentage of the time with cursors.

2011-11-03, 2694👍, 0💬