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
- 4872 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
What is a read only transaction in oracle?
What is proxy method?
How many types of tables supported by oracle?
What exactly do quotation marks around the table name do?
What are the different oracle database objects?
What is the difference between translate and replace in oracle?
What is the order of defining local variables and sub procedures/functions?
how to do daily transactions with out sql* loader control file regesterd in apps?
Why is oracle so popular?
How can I create database in oracle?
What is key preserved table?
How will you differentiate between varchar & varchar2?
How data locks are respected in oracle?
Explain a data segment?
What are the arithmetic operations?
