wt is view ? wht r the restrictions for view ?
- 3 Answers
- 6891 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikkal
A view we can treat it as a virtual table.
It doesn't have any physical existance.
A View can be created entirely from a single table or from
a number of tables with appropriate joins.
The mail Restriction in a view is that if a view made up of
more than one table then it can not update it.
(Obviously if the base table is not exists the db2 will
trow an error and u can not create the view)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How do I copy a table in db2?
What is db2 instance?
What is a page in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is the result of open cursor statement?
What is package in cobol db2?
How to find the number of rows in a db2 table?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the latest version of ibm db2?
Explain packages.
How does coalesce work?
What is syscat in db2?
What is ibm db2 used for?
Mention the various locks that are available in db2.
How to find the maximum value in a column in the db2 database?
