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 bind in db2?
What if we fail to give values in columns declared as NOT NULL ?
How to test SQL -911 error while developing COB-DB2 program
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.
What is multi row fetch in db2?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
how can i pull up a query which was previously stored in qmf
What technique is used to retrieve data from more than one table in a single SQL statement?
cursor with hold explain ?
How many databases can be created inside an instance in db2 ?
what is + sign and -ve sign for sql code ?
What is the use of DELGEN in DB2? Can we Write the program with out using it?