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
what is the difference between sql and t-sql? : Transact sql
What is error ora-01000: maximum open cursors exceeded
how to decrement dates by 1 in mysql? : Sql dba
How many types of functions are there in sql?
Why do we use %rowtype & %type in plsql?
What is the maximum number of columns in sql table?
what is timestamp in mysql? : Sql dba
What is the purpose of the primary key?
what is an index? : Sql dba
How to handle bulk data?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How much does sql certification cost?
How do I add a database to sql?
Which is faster view or stored procedure?
What are all types of user defined functions?