Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100877 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / sandeep singh
Advantages:
Cursors are somewhat like Pointers of Oracle, Oracle executes a query and assign some name to that memory location, which is known as Cursor.
Cursors are used for storing data temperarorily.
Cursors are used for storing, managing and retrieving data.
Cursors stores in the RAM so the data access and retrieval is fast.
Disadvantage:
No such disadvantage. Only thing is that rather than storing data in an intermediate variable and fetching it one by one via cursor and then processing it sequentially, we can use Collections. By using collections, we can pass the bundle of Data at once.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain about extended stored procedure?
What should be the fill factor for indexes created on tables? : sql server database administration
Can you index views?
What is the maximum size of a dimension? : sql server analysis services, ssas
How to fetch the next row from a cursor with a "fetch" statement?
What are the drawbacks of reporting in ssrs?
Do you know hot add cpu in sql server 2008?
What is the difference between sdf and mdf?
How to count groups returned with the group by clause in ms sql server?
Why is sql server log file full?
What are different types of subquery?
What is the importance of three tier architecture?
What are the differences between triggers and stored procedures?
what is normalization? Explain different levels of normalization? : Sql server database administration
Name 3 ways to get an accurate count of the number of records in a table?
