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's the error code for Unique Index Violation?
How many types of page locks can be held in db2?
What is the picture clause of the null indicator variable?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is a Resource Control Table(RCT)? Describe its characteristics.
wht are the restrictions for union ?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is RUNSTATS?
What is a cursor?
How do I import a csv file into db2?
What is host variable in db2 cobol?
How to access db2 tables in mainframe?