what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 24673 Views
- CG-VAK, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / meher
The main difference between cursor FETCH and FOR LOOP is as
below :
In case of cursor FETCH the cursor will open atleast once
but in case of cursor FOR LOOP the cursor will may or
maynot be open.
| Is This Answer Correct ? | 31 Yes | 8 No |
Post New Answer View All Answers
What are reports usually used for?
What do you mean by stored procedures? How do we use it?
How do you go back in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
what are the advantages a stored procedure? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
What is a procedure in pl sql?
Write a unique difference between a function and a stored procedure.
What is the purpose of the primary key?
what is rollback? : Sql dba
how to fetch alternate records from a table? : Sql dba
how to create a new table by selecting rows from another table in mysql? : Sql dba
How to return an array from java to pl/sql?
What is replication id?
How can we find duplicate records in a table?
