Difference between views and materialized views?
Answer Posted / a.jyothsna
VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
How to use sql statements in pl/sql?
How to add new employee details in an employee_details table with the following details
What is indexing oracle sql?
What is offset and limit in sql?
What is sql profiler in oracle?
What are different clauses used in sql?
What is the difference between an inner join and an outer join?
Can a key be both primary and foreign?
what is collation? : Sql dba
Can we write dml inside a function in sql server?
How to avoid duplicate records in a query?
What is an example of translating a date into julian format?
How many types of keys are there in sql?
Name the operator which is used in the query for pattern matching?
what is a foreign key ? : Sql dba