Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 12803 Views
- DELL, I also Faced
- E-Mail Answers
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 is user defined functions?
How does sql developer connect to oracle database?
What is primary key and foreign key with example?
What has stored procedures in sql and how we can use it?
What is sql injection vulnerability?
Is sql a backend language?
how to include character strings in sql statements? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
When is the explicit cursor used ?
Why do we use joins?
What is range partitioning?
How do I order by ascending in sql?
What are the query optimization techniques?
How many clustered indexes can be created on a table?
What is having clause in sql?
