Interested to Buy Any Domain ? << Click Here >> for more details...
What is a REF CURSOR? Compare strong and week ref cursor types.
- 6 Answers
- 28624 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 are character functions?
What are the advantages of pl sql over sql?
What if we write return in procedure?
Can you rollback after commit?
What is AUTH_ID and AUTH_USER in pl/sql ?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is not in sql?
What are the types of subqueries?
How to use boolean type in select statement?
What is difference between function and trigger?
How does cross join work in sql?
What are some predefined exceptions in pl/sql?
How do I know if I have sql express or standard?
What language is oracle sql developer?
How do I view tables in mysql?
