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
- 4817 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 |
Explain do view contain data?
can we insert any row to dual table if i got the permission from DBA
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
How does one get the view definition of fixed views/tables?
How to pass a parameter to a cursor in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to concatenate two text values in oracle?
What is java oracle used for?
when i run my query on yesterday it is fast but today it is slow why?
difference between truncate and delete ,drop?
What is meant by recursive hints in oracle?
What are the different types of modules in oracle forms?
Oracle General 
