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 does it mean to have quoted_identifier on? : Sql dba
Why do we need sharding?
What are the different operators available in sql?
What is not null in sql?
Why we use stored procedure instead of query?
What are schema-level triggers?
Why do we use triggers?
How can we store rows in PL/SQL using array?
What are the types of join in sql?
What is sql and its types?
What is the use of function "module procedure" in pl/sql?
What is Difference Between Unique and Primary Key Constraints?
What is compilation error in pl sql?
What is the benefit of foreign key?
What is a schema? How is it useful in sql servers?