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
- 11244 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 release/acquire in bind?
How and when does the db2 enforces the unique key?
Which is faster delete or truncate?
What is buffer pool and list some of them?
What is null value in db2?
What is db2 bind process?
Can one database have multiple instances?
What is ibm db2 client?
What is the use of commit in db2?
What is the difference between drop table and delete table?
What are iseries servers?
What is deadlock in db2?
what is the responsibility of the construction superintendent
define clustering index.
What is declare cursor?
