Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100199 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
How to use group functions in the select clause in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is b tree index?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is the architecture of ms sql reporting service?
What is the use of stored procedure?
Explain isolation levels that sql server supports?
What is field with example?
What is difference between global temporary tables and local temporary tables?
What is ems sql management studio? : sql server management studio
What is the difference between the application object and session object?
what is a deadlock? : Sql server database administration
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What are the differences between sql server and mysql.
Can a table be moved to different filegroup?
