view is a virtual table.view does not contain any data while material view

What is the differnce between view and materialized view

Question Posted / nivedita

Answer Posted / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is column?

948

How do I restart sql?

920

What is cost in sql execution plan?

917

Explain the advantages and disadvantages of stored procedure?

1089

What found sql?

908

What is field delimiter?

995

Explain the the update statement in sql?

998

Does inner join remove duplicates?

903

Which sql statement is used to return only different values?

961

What is date functions?

974

What is the primary use of normalization?

953

What are the different dml commands in sql?

1104

What is type and rowtype in pl sql?

978

How do I save a sql query?

972

What does <> sql mean?

1005