Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100947 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
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What are the differences between stored procedure and view in sql server?
How to write a query with a left outer join in ms sql server?
What is the difference between for auto and for nested?
Why truncate is ddl command?
What is dbcc updateusage?
Can You Use Data Mining Models In Ssrs?
what is denormalization and when would you go for it? : Sql server database administration
What is the native system stored procedure to execute a command against all databases?
What are the system database in sql server 2005?
What is the difference between count and distinct count?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Define right outer join in sql server joins?
What is tempdb in sql server?
What is it unwise to create wide clustered index keys?
