Cursor for loop is implicit cursor or explicit cursor?
Printable View
Cursor for loop is implicit cursor or explicit cursor?
implicit cursor.
It comes under Implicit Cursor.
it comes under explicit cursor, Cursor FOR LOOP automatically opens the cursor, loops through each row in the result set, and closes the cursor.
Cursor for loop,
For loop will fetch data for certain limitation but cursor for loop will fetch records upto end of the where clause and store it in cursor variable.