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


Please Help Members By Posting Answers For Below Questions

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

1674


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1585


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3431


How long can an error message be in raiseerror function?

548


What are the types of database model?

543






Explain about post-relational databases?

581


How would you design a database for an online site, which would average a million hits a day?

576


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?

547


What are the key features of dbms?

565


How to replace not in with not exist?

1460


Explain about relational operator join?

611


Who are end users in dbms?

548


What is DB Development software?

1615


Which data type cannot be used as a parameter in a udf?

574


State the acid rules?

682