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
- 10859 Views
- DELL, HCL, I also Faced
- E-Mail Answers
Answer Posted / diana
Yes you can update the table using cursor....
for eg: if you want to update 3 columns like A,B,C the you
can write as:
Update Table_name
Set A = :Host varaible(value)
B = :Host varaible(value)
C = :Host varaible(value)
where current of C1(Cursor name)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is universal database?
Which components manage deadlocks in db2?
Is db2 a database?
What is the difference between cursor stability and repeatable read isolation levels?
What does runstats do in db2?
What are the benefits of using the db2 database?
Can you tell me how can you find out the # of rows updated after an update statement?
What are the uses of db2 optimizer?
What is syscat in db2?
What types of tables are there in the db2 database?
What are the contents of dclgen?
What is innodb buffer pool?
How would the varchar column remarks defined?
What is bufferpool in db2?
What is performance tuning db2?
