Interested to Buy Any Domain ? << Click Here >> for more details...
can we update the table by using cursors can anyone post
the query?
- 5 Answers
- 11077 Views
- DELL, HCL, I also Faced
- E-Mail Answers
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
How can you do the explain of a dynamic sql statement?
What is drop table?
What do you mean by rollback?
What is a page in db2?
What is copy pending status in db2?
How to create db2 table in mainframe?
Which component is used to execute the sql statements?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What do you mean by between and in? Is between inclusive of specified range values?
Define check constraint.
What is node in db2?
What is commit in db2?
Explain the function done by data manager?
What is clone table?
What is a db2 package?
