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 sqlca’s maximum length?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
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.
How to execute stored procedures?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
what is the use of commit ? and what is the syntax?
What is subquery ?
What does DSNDB07 database do?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is reorg in database?
Are views updateable?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none