What Is a View?
- A view is nothing but a window of an existing table by which one can view and can also change the values in tables.
- The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables.
- Thus in other words a view is a database object that gives a logical representation of one or more database tables.
Advantages of Views
- To restrict data access.
- To make complex queries easy.
- To provide data independence.
- To present different views of the same data.
Simple Views and Complex Views
| Feature | Simple Views | Complex Views |
|---|---|---|
| Number of Tables | One | One or more |
| Contain Functions | No | Yes |
| Contain Group of Data | No | Yes |
No comments:
Post a Comment