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
Explain the use of indexes option in imp command.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is memory advisor in Oracle?
What is the difference between substr and instr?
How to login to the server without an instance?
What is a package ? What are the advantages of package ?
How to use fetch statement in a loop?
What is recycle bin in Oracle?
What is the difference between PFILE and SPFILE in Oracle?
What is concurrency in oracle?
How to retrieve data from an cursor to a record?
State some uses of redo log files?
How do I manually uninstall oracle client?
How to get execution path reports on query statements?
How do I connect to oracle database?
