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 is normalization? Explain different levels of normalization?
How to use timestamp datatypes
What is database design and development?
Explain about relational database management systems?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain the process of the user request and data generating?
Explain about post-relational databases?
Explain about the relational database?
Explain about relational operator join?
How can I detect whether a given connection is blocked?
What are the constraints on severity level in raiseerror?
Why does this query return 0?
What are the three types of database design?
In which database can extended stored procedures be added?