what is the difference between cursor FETCH and FOR LOOP ?
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 qualities of 2nf?
what are date and time data types in mysql? : Sql dba
What does select * from mean in sql?
What is group by in sql?
Can we enter data in a table in design view?
What are dml commands?
What does the file extension accdb stand for?
Which function is used to return remainder in a division operator in sql?
What is a schema sql?
how to increment dates by 1 in mysql? : Sql dba
Why do we use sqlite?
how can we know the number of days between two given dates using mysql? : Sql dba
What is pl sql architecture?
Can we use threading in pl/sql?
what is the difference between truncate and delete statement? : Transact sql