Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25567 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
How can we implement rollback or commit statement in a trigger?
What is normalisation in sql?
how to include character strings in sql statements? : Sql dba
what are the disadvantages of mysql? : Sql dba
What is data types in sql?
How does sql store data?
Explain architecture of sql server notification services?
What is group by in sql?
How do I start sql from command line?
How can a function retun more than one value in oracle with proper example?
Can we insert data into view?
What does select top 1 do in sql?
What is a trigger word?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is clustered index sql?
