Answer Posted / ashis
View is a virtual table or logical table or it can be
represented as mirror if table.View allows performing
transaction on table virtually.Table may contain "n" number
of views.View can be based on single table or more than one
table with help of join.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is ADDM Advisor in Oracle?
Explain an exception?
what happened to the global index when I truncate the data in one of the partition?
How to retrieve data from an explicit cursor?
How to create a single index for multiple columns?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to handle a single quote in oracle sql?
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?
What is the difference between hot backup and cold backup in oracle?
How to get a list of all background sessions in the database?
What is literal?
How to assign query results to variables?
How to write text literals in oracle?
What is a server parameter file in oracle?
What privilege is needed for a user to create tables in oracle?