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
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Explain the purpose of %type and %rowtype data types?
What is sql table?
What is the difference between the conventional and direct path loads? : aql loader
What is left join in sql?
What is the usage of distinct keyword?
Explain isolation levels. : Transact sql
How do you explain an index number?
What do you mean by rowid?
What has stored procedures in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is the difference between having clause and where clause?
how to calculate the difference between two dates? : Sql dba
What are types of indexes in sql?
How to test for null values?