Types of cursors and explanation each of them ?
Answer Posted / sohail
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
where are cookies actually stored on the hard disk? : Sql dba
What is the life of an sql statement?
What do you mean by stored procedures? How do we use it?
Is sql microsoft?
What is posting?
Is sqlite free?
What are the two virtual tables available at the time of database trigger execution?
Does sql require a server?
Is hadoop a nosql?
What is nosql db?
Explain the uses of database trigger.
Why is a trigger used?
How many joins in sql?
Why query optimization is needed?
what are different types of collation sensitivity? : Sql dba