can we update the table by using cursors can anyone post
the query?
Answer Posted / siri
suppose we want update ename in emp table using cursor....
declare crsorname cursor for
select * from emp
where dept='d005'
for update of ename....
upate emp
set ename=:ename
where current of cursor
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List out the buffer pools in db2
What is the clustering index in the db2 database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the latest version of ibm db2?
Mention the different locking levels that are available in db2.
How do you select a row using indexes in db2?
What does reorg do in db2?
What is null indicator in cobol db2?
Where do you specify them?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to run db2 command in windows?
What is an instance in db2?
What does db2 stand for?
What is syscat in db2?
Highlight all the advantages that are attached to a package.