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
- 4875 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 |
How to create a table in a specific tablespace?
what is dynamic SGA and static SGA
How to drop a stored procedure in oracle?
How to manage transaction isolation level?
where do i find oracle interview questions.
What is a sub query? Describe its types?
What is a cluster Key ?
What are the types of partitions in oracle?
What is difference between SUBSTR and INSTR?
State some uses of redo log files?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are the advantages of Views ?
Oracle General 
