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
What is local temp table?
Explain the difference between delete,drop and truncate in SQL Server?
What is a hint?
What is user defined datatypes and when you should go for them?
what are the three command line utilities and what are their primary functions?
How do I open port 1433?
What are scalar functions?
How to delete duplicate records based on single column from a table?
What are the differences between substr and charindex in sql server.
What is data modification?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is a transaction and why is it important?
How connect excel to sql server?
How to send email from database?
Can foreign key be deleted?
