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
- 4816 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 are the differences between char and nchar in oracle?
How to create an initialization parameter file?
What are the built-in functions used for sending Parameters to forms ?
How to get the Installed Oracle Version Information ?
Explain the difference between sap and oracle?
How to drop a tablespace?
How to do clean up if create database failed?
What the is the diff between local index and global index. give some example.
What are a query and state the different types of queries and their uses?
Explain user account with reference to oracle.
What is the difference between I and G in Oracle?
How to get a list of all user accounts in the database?
What is an index associated with a constraint?
What is the scope of a local variable?
what is the use of system.effective.date variable in oracle?
