If I have a view which is a join of two or more tables, can
this view be updatable?

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


Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

608


What is load replace in db2?

568


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1610


what is the sqlcode -501

11359


What is null indicator in db2?

615






What is explain in db2?

593


Is db2 a mainframe database?

579


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

595


How to run db2 command in windows?

662


How can you count the number of rows from a table tab?

647


Explain the contention situations caused by locks?

607


Why db2 is called db2?

608


Explain the function of data manager.

653


When reorg is used?

689


What is the role of the data page in the db2 database?

597