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
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
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
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How long can an error message be in raiseerror function?
What are the types of database model?
Explain about post-relational databases?
How would you design a database for an online site, which would average a million hits a day?
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?
What are the key features of dbms?
How to replace not in with not exist?
Explain about relational operator join?
Who are end users in dbms?
What is DB Development software?
Which data type cannot be used as a parameter in a udf?
State the acid rules?