Interested to Buy Any Domain ? << Click Here >> for more details...
If I have a view which is a join of two or more tables, can
this view be updatable?
- 3 Answers
- 7388 Views
- I also Faced
- E-Mail Answers
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 |
Name the various locking levels available?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is explain in db2?
When is the access path determined for dynamic SQL?
What is a collection?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is cobol db2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
Which component is responsible for processing sql statements and selecting access paths?
On which levels locks can be applied?
Which catalog table stores referential constraints?
Mention the different locking levels that are available in db2.
COBOL 
