Interested to Buy Any Domain ? << Click Here >> for more details...
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
- 1 Answers
- 3226 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
Define full outer join in sql server joins?
Can I delete event logs?
What are the different normalization forms?
How many categories of functions based their return modes?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Can sub report data source be different from that of the parent report?
Can sql servers linked to other servers?
What are the 10 characteristics of data quality?
Name some of the open source software that you can use in alternative to SSR?
How to assign null values to variables or columns?
What is b tree index?
What is the usage of the sign function?
Explain mixed authentication mode of sql server?
What is the ‘fillfactor’?
What do you mean by recursive stored procedure?
