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 |
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is the minimum client footprint required to connect c# to an oracle database?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is mean by Program Global Area (PGA) ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to name query output columns in oracle?
Can a formula column referred to columns in higher group ?
How to load a large xml file?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
How to call a stored function in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?