What is a REF CURSOR? Compare strong and week ref cursor types.
Answer Posted / b.v.srinivas
Ref cursor is a cursor variable which acts as a pointer to
the sql memory area.
Ref cursor can be asssociated with multiple sql statements
where as a cursor can be associated with only one sql
statement.
Refcursor is dynamic where as cursor is static.
Ref cursors are of two types:
1)strong ref cursor:which retuns value.
2)week ref cursor:which doesn't return value.
thanks and regards
B.V.Srinivas.
Is This Answer Correct ? | 32 Yes | 5 No |
Post New Answer View All Answers
what is row? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is database sql?
How do you update a value in sql?
What is mutating error?
What is program debugging?
What is the use of count (*) in sql?
What is a common use of group by in sql?
what is a table in a database ? : Sql dba
What is sql injection vulnerability?
What are the qualities of 2nf?
Can function return multiple values in sql?
What is linq to sql?
tell me about various levels of constraint. : Sql dba
What is the primary use of normalization?