Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25715 Views
- CG-VAK, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar
The cursor FOR LOOP implicitly declare loop index as a
record of %ROWTYPE open a cursor implicity and repeatedly
fetch the records from the active set into the field of
record, then close the cursor implictly all rows have been
processed.
In case of cursor FETCH explicity open a cursor, fetch the
records and close the cursor.
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
What are the possible values that can be stored in a boolean data field?
What does partition by mean in sql?
What is cursor status?
What is multiple partition?
What is left join example?
How do I create a memory optimized filegroup?
What is use of term?
What is serial sql?
How you improve the performance of sql*loader? : aql loader
How do you create a unique index?
What is natural join in sql?
What are the advantages of pl sql over sql?
How can you fetch common records from two tables?
What is meant by <> in sql?
Does sql between include endpoints?
