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 is pl sql script?
Is oracle and sql same?
What is percent sign in sql?
how to rename an existing table in mysql? : Sql dba
What are sql injection vulnerabilities?
What is the difference between nvl function, ifnull function, and isnull function?
How do I view a sql trace file?
How many joins in sql?
Why is partition used in sql?
How do you rename a table in sql?
what is the difference between char and varchar data types? : Sql dba
Can a commit statement be executed as part of a trigger?
What is where clause in sql?
What is type and rowtype in pl sql?
how to include character strings in sql statements? : Sql dba