What is the difference between base table and view?
Answer Posted / priya
using views complex queries can be solved easily
as it provides multiple table join facility
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a corelated subquerry?
What is the role of schema in the db2 database?
What do you mean by commit and rollback?
What is copy pending status in db2?
What is collection in db2 bind?
What is the difference between spufi and qmf?
What is the result of open cursor statement?
What is coalesce in db2?
What is a collection in db2?
What are concurrency issues?
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.
Why do we bind in db2?
How to compare data between two tables in db2?
Is it possible using max on a char column?
What is dbrm?