What are cursors? Explain different types of cursors?
Answer Posted / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
State the acid rules?
How to customize error conditions.
What are the constraints on severity level in raiseerror?
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?
What is data modeling with example?
How can you fix a poorly performing query?
Explain the role of indexing in databases?
Write the fastest query to find out how many rows exist in a table?
In which table collections errors are stored.
Explain about the storage and physical database design?
Who are naive users?
What is the physical representation for a many-to-many relationship?
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
Where is dbms used?
How to generate OIDS