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
- 11076 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 copy pending and check pending in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
can we view the access paths created by dbrm ? how ? thx
What is precompiler in db2?
What is the difference between spufi and qmf?
What is clone table?
What are the various data types available in db2?
What is the difference between nvl and coalesce?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain packages.
What is load replace in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the difference between using bind () and rebind () methods of naming class?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Name the lockable units in DB2?
