Advantages and Disadvantages of Cursor?
- 15 Answers
- 97971 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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Will the writetext statement activate a trigger?
what are the different stages of Report Processing?
Explain foreign key in sql server?
what is the maximum size of a row? : Sql server database administration
Explain table valued parameters in sql server? Why tvp used?
What is implicit mode in sql server?
What is meant by datasource?
Using the customer, and order table in northwind database, please write a query to produce xml?
What is a field name?
Where sql server usernames and passwords are stored in a sql server?
What is sql or structured query language?
Explain raiserror in sql server?
What are user-defined functions (udfs) in sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
Tell me extended events in sql server 2008?
