Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / akn
If we have several tables in a DB and we want to view only
specific columns from specific tables we can go for
views.It would also suffice the needs of security sometimes
allowing specific users to see only specific columns based
on the permission that we can configure on the view. Views
also reduce the effort that is required for writing queries
to access specific columns every time
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is an oracle database?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to select an oracle system id (sid)?
How to write an inner join with the where clause in oracle?
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?
What is the use of aggregate functions in oracle?
how to join query for one source type is oracle another source type is sql server ?
Does facebook use oracle?
What do you understand by a database object?
Which environment variables are absolutely critical in order to run the OUI?
What is the usage of synonyms?
What is the difference between online and offline backups?
What are the oracle differences between nvl and coalesce
How to loop through a cursor variable?
Are truncate and delete commands same? If so why?
