what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 24672 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 is the use of non clustered index?
Can there be 2 primary keys in a table?
How do you write a complex sql query?
What is the difference between nested table and varray?
What is varchar data type in sql?
How is a PL/SQL code compiled?
how to convert numeric values to character strings? : Sql dba
Does inner join return duplicate rows?
what is primary key? : Sql dba
What does select * from mean in sql?
What are different types of queries in sql?
List the ways to get the count of records in a table?
What are all the different normalizations?
What are the constraints available in sql?
Can two tables have same primary key?
