Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 101403 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 how to send email from sql database?
How to create an index on a view?
Explain trigger classes i.e. Instead of and after trigger?
What is an identity?
Define indexes?
What is the recovery model?
Difference between connected and disconnected database in .net with sql server?
What happens when converting big values to integers?
How to get a list all databases on the sql server?
Is sql server free?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Which autogrowth database setting is good?
What does set rowcount do?
How to enter comments in transact-sql statements?
Do you know what is fill factor and pad index?
