If I have a view which is a join of two or more tables, can
this view be updatable?
- 3 Answers
- 5661 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 bind process?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the physical storage length of the data types date, time, and timestamp?
What is the difference between db2 and oracle?
Explain the contents that are a part of dclgen.
What do you mean by commit and rollback?
Which is faster delete or truncate?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the max length of sqlca?
What is the purpose of rollback and commit?
What is the result of open cursor statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Why do we bind in db2?
What is dbrm in db2 database?
Explain about open switch business continuity software?
