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 |
can we view the access paths created by dbrm ? how ? thx
wht happens if we close cursor with cursor with hold option?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What are the advantages of using a PACKAGE?
What is a view? Why use it?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are concurrency issues?
How to resolve -917 sql code in DB2?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is a cursor in programming?