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 is pagespace?
Describe the elements of the SELECT query syntax?
What is the difference between TYPE 1 index & TYPE 2 index
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
How to get the ddl of a table in db2?
What do the initials DDL and DML stand for and what is their meaning?
What are some characteristics of columns that benefit from indexes?
What should be specified along with a cursor in order to continue updating process after commit?
What does DSNDB07 database do?
What is rct?
what types of copies can be made with the COPY Utility ?
What is the physical storage length of date data type?