What are cursors? Explain different types of cursors?
Answer Posted / siva
cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
State the acid rules?
What is a database development?
What are the main phases of database development?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain the rollup operator?
What is normalization? Explain different levels of normalization?
How can you log an error to the server event log from a stored procedure?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to generate OIDS
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about the storage and physical database design?
What is the physical representation for a many-to-many relationship?
Explain about relational database management systems?
Explain about normal forms?
In which database can extended stored procedures be added?