One can not make update operation on a view that has a join from more than

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

Question Posted / mahesh vasudevan

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

Please Help Members By Posting Answers For Below Questions

What is cursor in dbms?

1073

What is dclgen (declaration generator)?

1064

What is the maximum No of rows per page?

1072

What are the two types of logging in the db2 database? Explain them.

1078

What is an instance in db2?

1039

What db2 400?

1203

Before you give the explain statement, what are the prerogatives?

1044

What is dbrm in db2 database?

1123

What is query_cache_limit?

977

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1105

Which isolation level provides highest data integrity?

1126

When reorg is used?

1134

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1201

What is meant by union and union all?

1012

How to find the number of rows in a db2 table?

1120