Are views updatable ?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
Not all of them. Some views are updatable e.g. single table
view with all the fields or mandatory fields. Examples of
non-updatable views are views which are joins, views that
contain aggregate functions (such as MIN), and views that
have GROUP BY clause.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / shankar
Yes but only for those views which are created with UPDATE
option.
| Is This Answer Correct ? | 5 Yes | 4 No |
What does an outer join do?
How do you Load a table ?? and what is Load replace ?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What are the disadvantages of PAGE level lock?
What is commit in db2?
What is lock contention?
Discuss about db2 bind?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What information is held in SYSIBM.SYSCOPY?
What is innodb buffer pool?
How can you classify the locks in db2?