If I have a view which is a join of two or more tables, can
this view be updatable?
Answers were Sorted based on User's Feedback
Answer / guest
If view has join that time view can not be updatable.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mahesh vasudevan
One can not make update operation on a view that has a join
from more than two or more tables.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Primary key and unique index?
How would you find out the total number of rows in a db2 table?
what is + sign and -ve sign for sql code ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is a db2 package?
how to resolve -811 sqlcode .give clear explaination
What is check constraint. Explain with example.
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Which transaction use a command thread ?
What information is used as input to the bind process?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What Utility is used to migrate DB2 from one release to the next?