Interested to Buy Any Domain ? << Click Here >> for more details...
Are views updatable ?
- 4 Answers
- 12549 Views
- I also Faced
- E-Mail Answers
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 |
how to resolve -811 sqlcode .give clear explaination
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do you stop a db2 database in linux?
What is a page?
How do I connect my db2 database to ibm?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is correlation names?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
how will you retrieve first record in table
can we drop column from a table
Explain the EXPLAIN statement?
COBOL 
