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
Which is faster subquery or join?
How do you declare a user-defined exception?
how to get a list of indexes of an existing table? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
Can a commit statement be executed as part of a trigger?
How do you truncate?
What mean sql?
What is varchar used for?
how to get a list of all tables in a database? : Sql dba
What is the best partition size for windows 10?
What is substitution variable?
What is difference sql and mysql?
What is the starting oracle error number? What is meant by forward declaration in functions?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is a behavioral trigger?