Advantages and Disadvantages of Cursor?
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
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
How can I tell if sql server is 32 or 64 bit?
What are advantages of ssrs or why we should use ssrs?
What is sql server english query?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How does stuff differ from the replace function?
explain different types of constraints? : Sql server database administration
What are recommended options to be used while using db mirroring? : sql server database administration
What is ms sql server service broker?
What are the requirements to use odbc connections in php scripts?
How many joins in sql server?
What are the security related catalog views? : sql server security
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Define cursor locking
What is explicit mode in sql server?