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
Is not equal in sql?
What is the need of merge statement?
Define commit?
What are the advantages of indexing?
How many unique keys can a table have?
what is uncommittable transactions? : Transact sql
Explain the purpose of %type and %rowtype data types with the example?
What are sql queries used for?
What is full form of rtm?
What is the need of a partition key?
How do you copy a table in sql?
What is sql partition?
What is blind sql injection?
What is procedure in pl sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?