Types of cursors and explanation each of them ?
Answer Posted / aditya
Ref cursor have two types strong ref cursor and weak ref cursor.
declaring a ref cursor and using it for multiple select statements is a weak cursor.
using a ref cursor as an out parameter to get a result set is a strong ref cursor.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can a commit statement be executed as part of a trigger?
What are different joins used in sql?
Mention what does the hierarchical profiler does?
What is sql engine in oracle?
how to use case expression? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
Is sqlite good enough for production?
What is an invalid partition table?
How delete a row in sql?
Explain the update statement in sql
What is varray in pl sql?
Explain what is a database?
What are the different sql commands?
What do you understand by case manipulation functions?
What is information schema in sql?