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
How to create tables for odbc connection testing?
What is connection pool in oracle?
How to convert raw data type into text in oracle? Explain
How to drop a tablespace?
How to define an anonymous block?
How to write text literals 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?
How can we create the complete backup of data in the oracle.
How to assign values to variables?
How to convert characters to times in oracle?
What is set verify off in oracle?
How to define a variable of a specific record type?
Explain the use of consistent option in exp command.
What are joins, explain all types of joins?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
