Types of cursors and explanation each of them ?
- 4 Answers
- 11635 Views
- DELL, I also Faced
- E-Mail Answers
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
Why we use join in sql?
What is data profiling in sql?
Explain what is a database?
What is the best free sql database?
What do you mean by stored procedures?
What is an invalid partition table?
What are the disadvantages of file system?
Can a commit statement be executed as part of a trigger?
How many developers work on postgresql?
What is oracle sql called?
What is sqlerrm?
What is rownum?
Is sql a scripting language?
What is query syntax?
What is trigger with example?
