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
- 3077 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is clustered index
What are the different types of collation sensitivity in sql server?
How to recompile stored procedure at run time?
How to add additional conditions in SQL?
What is onf in normalization form?
what do you understand by change data capture?
What does the INSTEAD OF trigger do?
Which trace flags are enabled in sql server?
What is the difference between a view and a stored procedure?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Do you know hot add cpu in sql server 2008?
how can you attach more than 20 ldf files in sql server
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
