Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between table and view? where to use views?
thanks in advance!
- 1 Answers
- 4822 Views
- I also Faced
- E-Mail Answers
Answer / shalini
A table is a collection of data in the form of rows and
columns.
Whereas a View is a virtual table in which data comes from
one or more base tables and is stored as a result of a
predefined query for further use.
Uses of Views:
1.used to improve performance as they are the results of
predefined/complex queries which can be used in other
queries.
2.To provide security by granting permissions to certain
group of people only on the views rather than all the
tables database .ie. hiding sensitive data.
3.To hide complexity of data by showing only the relevant
data need to show to a user rather than confusing a uaser
by showing all the information
| Is This Answer Correct ? | 11 Yes | 0 No |
Use of an integrity constraint is better to validate data. Explain
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to bring a tablespace offline?
Do View contain Data ?
What are the differences between interval year to month and interval day to second?
Differentiate between post-database commit and post-form commit?
How to export data to a csv file?
why dont we assign not null constraint as table level constraint.
How to download oracle database 10g xe?
How do we create privileges in oracle?
How many data types are supported?
What is Row Chaining ?
Oracle General 
