what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
- 1 Answers
- 2514 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya gurrala
Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.
Cursor is required to process each row individually for queries which return multiple rows.
Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.
Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What the difference between UNION and UNIONALL?
What are the new scripting capabilities of ssms? : sql server management studio
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is the order by used for?
What are the different ways you can create databases in sql server?
What are “unrepeatable reads”?
What are the types of resultset?
What are the export options of ssrs?
Why does sql studio use a single registered database repository? : sql server management studio
What is the openxml statement in sql server?
What is the difference between having clause and where clause in sql server?
What is a result set object returned by mssql_query()?
What is history table in sql server?
What are database states in ms sql server?
Mention the differences between local and global temporary tables.
