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
- 4794 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 |
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Explain table?
What are the ansi data types supported in oracle?
What happens in oracle commit?
how to we delete a row using varray
What is Public Database Link ?
how to find out second largest value in the table
what is the exact diiference between DBMS and RDBMS
What is an oracle database table?
What is the difference between 10g OEM and 11g OEM?
What is a initialization parameter file in oracle?
How do you rate yourself in oracle and sql server ?
Oracle General 
