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 you please explain the difference between function and stored procedure?
When to use null data driven subscription?
1 01 101 01010
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
how to take backup bcp out for a column in table in sql server?
How to start sql server browser service?
How efficient you are in oracle and SQL server?
What do you understand by a view? What does the with check option clause for a view do?
what are database files and filegroups? : Sql server database administration
What is coalesce in sql server?
What happens if ntwdblib.dll is missing on your machine?
What is a view in sql?
Is it possible to update the views? If yes, how, if not, why?
Explain the working of sql privileges?