What is a cursor for loop?

Cursor For Loop is a loop where oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record.

Interview Candidate
Aug 29th, 2004
12
2440

SQL

Answer

Showing Answers 1 - 12 of 12 Answers

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 12th, 2006

in cursor for loop: %open, %fetch, %close is controlled automaticaly by loop
and user need not worry ablut %fond

syam sundar

Aug 17th, 2007

In cursor for loop all cursor jobs are controled by loop.
means incursor for loop %open, %fetch, %close and %found
user need not bother about that

g_sidhu
Profile

Feb 6th, 2008

The cursor FOR loop is a shortcut to process
explicit cursors.
Implicit open, fetch, exit, and close occur.
The record is implicitly declared.

narmadac
Profile Answers by narmadac

Feb 11th, 2010

A cursor for loop can be used instead of explicit cursors. A cursor for loop implicitly opens, fetches rows, closes a cursor.