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
- 4711 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 use "for" statements in oracle?
How to connect the oracle server as sysdba?
can u plz provide me oca sql dumps please i need them
When do I need to use a semicolon vs a slash in oracle sql?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What do you mean by merge in oracle and how can we merge two tables?
how to we delete a row using varray
Why oracle is used?
What are the different types of trigger and explain its various uses and functions?
What is snapshot is too old? Give and example for better understand.
What is blob datatype?
Who developed oracle & when?
Oracle General 
