What are cursors? Explain different types of cursors?
Answer Posted / preethi
Cursors are work areas used for internal processing in
order toexecute an SQL statement.
Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors
Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about relational operator join?
What is the maximum length of an extended property?
Explain about the hierarchical model of the database?
Which four data types cannot be used as a return type from a user-defined function?
Explain about query and reporting.
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How to use online Backups?
Can an extended stored procedure be called from inside a user-defined function?
How can you fix a poorly performing query?
What is database design and development?
How long can an error message be in raiseerror function?
Explain what a database is?
Explain about the storage and physical database design?
What is DB Development software?