can we update the table by using cursors can anyone post
the query?
Answer Posted / bigben
yes you can
declare cursor using FOR UPDATE option
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How do I import a csv file into db2?
what is the responsibility of the construction superintendent
What is reorg?
What is copy pending and check pending in db2?
How to fetch the last row from the table in SQL (db2)?
Before you give the explain statement, what are the prerogatives?
What are the prerogatives?
Explain the contents that are a part of dclgen.
Are view updateable?
What are host variables in db2?
Why db2 is called db2?
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
What is the physical storage length of the data types date, time, and timestamp?
What is precompiler in db2?