Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 28839 Views
- I also Faced
- E-Mail Answers
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
How to combine two function together?
Explain the process of the user request and data generating?
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?
How long can an error message be in raiseerror function?
What are the main phases of database development?
How to use timestamp datatypes
How can you log an error to the server event log from a stored procedure?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the constraints on severity level in raiseerror?
What is an application role and explain a scenario when you would use one?
How can I detect whether a given connection is blocked?
How to read and create .LDC data files which are used by linguatic dictionary.
What are the three basic rules which are to be followed for the relational model of the database?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is database design and development?
