What is a cursor for loop ?

Question Posted / guest

4 Answers
8141 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a cursor for loop ?..

Answer / anil kumar jampana

cursor for loop is also a cursor. Here no need to handle
open,fetch,close operations. These operations are handled
by for loop.

Is This Answer Correct ?

8 Yes

0 No

What is a cursor for loop ?..

Answer / dipti

Another nice feature of the CURSOR FOR is the ability to
define the cursor inline. Below is a cursor that is not
declared in the declaration section of the executing
block. The cursor definition is included in the CURSOR FOR.
SQL> begin
2 for r_c11 in
(select author_last_name l_name,
3 author_first_name f_name
4 from author) loop
5 dbms_output.put_line(initcap(
6 r_c11.l_name||
', '||r_c11.f_name));
7 end loop;
8 end;
9

Is This Answer Correct ?

4 Yes

1 No

What is a cursor for loop ?..

Answer / nishi

cursor for loop is also a cursor. Here no need to handle open, fetch, close operations. These operations are handled by for loop.

Is This Answer Correct ?

0 Yes

0 No

What is a cursor for loop ?..

Answer / suresh somayajula

Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer