what is the difference between cursor FETCH and FOR LOOP ?
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
Why triggers are used?
Can primary key be changed?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is memory optimized?
what are date and time data types in mysql? : Sql dba
What is an oracle stored procedure?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Can we perform dml in function?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What does seeding a database mean?
Who is the owner of mysql database?
How much does sqlite cost?
Does user triggers have entry for trigger with compilation errors?
Why function is used in sql?
How to look at the current sql*plus system settings?