Answer Posted / kalyana chakravarthy
View is a taliored representation of data of a particular
table. In one way to say view is a shadow of a table. What
ever U do on a view will reflect on the table vice versa.
Views r 2 types simple and complex simple is selected rows
from one table and complex is selected from more than one.
In oracle complex view can be updated by using instead of
triggers from version 8.0
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can sql servers linked to other servers?
Explain different types of collation sensitivity?
What are sql server functions?
If we delete pack Spec what will be the status of pack Body ?
What is use of except clause? How does it differ from not in clause?
How we can refresh the view?
What is ms sql server reporting services?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How can you tell if a database object is invalid?
Describe the functionalities that views support.
How to find Duplicate Records In table?
how to take backup bcp out for a column in table in sql server?
role of sql sever 2005 in database rather than any other database
What is Cross Join and in which scenario do we use Cross Join?
How to find out what is the default collation in a database?
