Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25916 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 disadvantages of file system?
What are the differences between in and exists clause?
What is the reports view in oracle sql developer?
what is the difference between truncate and delete statement? : Transact sql
what are the advantages of sql ? : Sql dba
What is sqlca in powerbuilder?
What are string functions in sql?
What are different sql data types?
What is record type in pl sql?
Is pl sql and postgresql same?
Enlist the data types that can be used in pl/sql?
Does view contain data?
What is PL/SQL Records?
Can a select statement fire a trigger?
Show the cursor attributes of pl/sql.
