what is difference between table and view? where to use views?
thanks in advance!
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 |
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
Which Oracle App Is Most Popular One ?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Please explain oracle data types with examples?
Query to retrieve record for a many to many relationship ?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
i want department wise maxmum salary and empolyee name
What are the different types of failures that occur in Oracle database?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
List the parts of a database trigger.
What do you understand by a database object?