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
What are the most important ddl statements in sql?
How many indexes can be created on a table in sql?
Define concurrency control. : Transact sql
What is the difference between delete and truncate commands?
what is foreign key? : Sql dba
What is foreign key and example?
What is the use of stored procedures?
Explain the difference between sql and mysql.
what are integrity rules?
How do you sort in sql?
what are the types of join and explain each? : Sql dba
What is sqlite used for?
What is data types in sql?
What is data control language?
how to convert character strings to numeric values? : Sql dba