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
- 4739 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 |
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
Explain implicit cursor.
what are pseudocolumns?
How would you design a database for an e-commerce website?
What is use of oracle?
How to create a new oracle data file?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Why do you create or replace procedures rather that drop and recreate.
How you find out version of installed workflow?
How to find out what privileges a user currently has in oracle?
What happens if you set the sga too low in oracle?
What are the different editions of oracle?
Oracle General 
