A view will takes the output of the query. But a materialized view stores

What is the differnce between view and materialized view

Question Posted / yaswanth

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

Please Help Members By Posting Answers For Below Questions

The select into statement is most often used to create backup copies of tables or for archiving records?

1010

Explain the significance of the & and && operators in pl sql.

963

How do I save a stored procedure?

954

Is it possible to link two groups inside a cross products after the cross products group has been created?

961

What is the difference between delete and truncate statement in sql?

1015

What is the difference between inner join and left join?

944

Why schema is used in sql?

995

What are different functions in sql?

903

What is the sql*loader? : aql loader

1017

What is a full join?

921

How do temporal tables work?

916

How do I run a pl sql procedure in sql developer?

921

What are different types of sql commands?

1035

Which data type is a composite type?

941

Define implicit and explicit cursors.

1087