SQL - What is a cursor for loop?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 33 of 171

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.

Total Answers and Comments: 3

Last Update: February 06, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 12, 2006 09:04:40

rampratap409

Member Since: September 2006 Contribution: 111

RE: What is a cursor for loop?

in cursor for loop: open fetch close is controlled automaticaly by loop

and user need not worry ablut fond

Is this answer useful? Yes | No

August 17, 2007 08:39:11

syam sundar

RE: What is a cursor for loop?

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

Is this answer useful? Yes | No

February 06, 2008 14:48:05

g_sidhu

Member Since: August 2007 Contribution: 122

RE: What is a cursor for loop?

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank