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 |
Compare a subselect to a join?
what is a collection?
Why select is not preferred in embedded sql programs?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What are the two types of logging in the db2 database? Explain them.
What is a db2 schema?
What is the use of commit in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is reorg in DB2
How many buffer pools are available in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?