Answer Posted / amadur
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can a formula column be obtained through a select statement ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Is oracle an open source?
What types of joins are used in writing subqueries?
How to compare dates in oracle sql?
How do I manually create a database in oracle?
candidate key is subset of super key but not vice-verse explain
Please explain oracle data types with examples?
How can I combine multiple rows into a comma-delimited list in oracle?
query optmization techniques and quwry analyser+projects+ppts
What are the oracle differences between nvl and coalesce
why dont we assign not null constraint as table level constraint.
How to use "for" statements in oracle?
How to initialize variables with default values?
How do I use os authentication with weblogic jdriver for oracle and connection pools?