What is the differnce between view and materialized view

Answer Posted / yaswanth

A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to extract a unit value from a date and time? : Sql dba

556


what is blob? : Sql dba

564


What is the difference between a procedure and a function?

494


What are different methods to trace the pl/sql code?

544


What does <> sql mean?

542






What is set serveroutput on?

642


Why is the cursor important?

543


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

547


what is sub-query? : Transact sql

599


What is use of trigger?

515


Can there be more than one function with a similar name in a pl/sql block?

547


What are all ddl commands?

549


How do you respond to dementia behavior?

533


define data blocks ? : Sql dba

547


Why do we need cursor in pl sql?

649