How to update more then one record using update?
Answer Posted / sivakumar sekharannair
update query without "where" command will update multiple
rows in the table;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is a corelated subquerry?
What is the clustering index in the db2 database?
How do I copy a table in db2?
Can we insert update delete in view?
Give the name of some fields form sqlca.
Explain the function done by data manager?
What is the difference between nvl and coalesce?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the usage of open cursor command?
What is meant by explain?
What are the prerogatives?
Give a brief description of db2 isolation levels?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is dbrm?
What are types of indexes?