What is a REF CURSOR? Compare strong and week ref cursor types.
- 6 Answers
- 27388 Views
- I also Faced
- E-Mail Answers
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 a pl/sql block?
What is trigger in pl sql with examples?
Does user triggers have entry for trigger with compilation errors?
How do we accept inputs from user during runtime?
How much does sql certification cost?
What are its different types of dbms?
What is sql dialect?
what is 'mysqldump'? : Sql dba
How do you exit in sql?
What is the difference between a procedure and a function?
How can I change database name in sql?
Is primary key an index?
How do I pipe the output of one isql to another?
Why partition by is used in sql?
What is the usage of nvl function?
