Answer Posted / s
Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Define predicate?
How to fetch the last row from the table in SQL (db2)?
How would the varchar column remarks defined?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Which component is responsible for processing sql statements and selecting access paths?
What is package in db2 mainframe?
what is diffrence b/w file-aid tool and file-aid utility???
What is dbrm in db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How is a typical db2 batch pgm executed?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is explain in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the difference between drop table and delete table?
What is nvl in db2?