Types of cursors and explanation each of them ?
Answer Posted / anusha
Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is sql a case sensitive language?
What are the possible values that can be stored in a boolean data field?
What is the clause we need to add in function body to return variable?
What does subquery mean in sql?
What found sql?
What does sql stand for?
What is count * in sql?
What are the properties of a transaction?
Why is partition used in sql?
How do I view tables in sql developer?
What is the difference between truncate and drop statements?
What does sign mean sql?
what is the use of double ampersand (&&) in sql queries?
What is the difference between an inner and outer join?
what is try_catch block in procedure