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
- 4792 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we call procedure inside function in oracle?
How to set up autotrace for a user account?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is recovery manager in Oracle?
How to convert characters to dates in oracle?
What happens to the current transaction if the session is killed?
What is the usage of analyze command in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a directory object?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What exactly do quotation marks around the table name do?
How to invoke the data pump import utility?
What is the difference between pre-select and pre-query?
How to use "startup" command to start default instance?
How to connect ms access to oracle servers?
