VIEWS: Takes the output of a query M.VIEWS: Stores the output of a query,

Difference between views and materialized views?

Question Posted / a.jyothsna

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

Please Help Members By Posting Answers For Below Questions

what is sql profiler? : Sql dba

1023

Is stored procedure faster than query?

946

explain access control lists. : Sql dba

977

What is the best sql course?

970

What does inner join mean?

1135

What is sql and explain its components?

1043

Which are sql * plus commands?

1104

What are different sql data types?

1012

What is relationship? How many types of relationship are there?

1148

Can we use insert statement in function?

980

What's the difference between inner join and left join?

982

Why stored procedures are faster than query?

1006

what are the advantages of sql ? : Sql dba

1041

Mention what does plv msg allows you to do?

1096

How to order siblings in oracle hierarchy queries?

1019