Interested to Buy Any Domain ? << Click Here >> for more details...
What is a REF CURSOR? Compare strong and week ref cursor types.
- 6 Answers
- 28589 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 pl/sql package consists of?
How do you bind variables in pl sql?
What is loop in pl sql?
what is 'mysqladmin' in mysql? : Sql dba
Why sql query is slow?
what is sql in mysql? : Sql dba
What company owns postgresql?
What is the difference between microsoft sql and mysql?
What are few of the schema objects that are created using PL/SQL?
what are the advantages a stored procedure? : Sql dba
Does pdo prevent sql injection?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is nvarchar in sql?
How are sql commands classified?
What is your daily office routine?
