Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25538 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 do I count rows in sql?
What is bulk collect in pl sql?
What is the usage of nvl function?
Can a trigger call a stored procedure?
What is execution plan in sql?
What is an inconsistent dependency?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the possible values for the boolean data field?
What is sql and also describe types of sql statements?
When to use inner join and left join?
What is a sql select statement?
tell me about various levels of constraint. : Sql dba
Explain 3 basic parts of a trigger.
what is a constraint? Tell me about its various levels. : Sql dba
Are sql database names case sensitive?
