Delete comment from: Java67
View is a database object and also views are used to we can store data from table.views created on tables Oracle having the following types of views these are.
1.simple views
2.complex views
1.simple view
Simple views are used to we can not
store data into database or horddiskha when ever we are droping a base table then auto matically views are not accessible wheare as when ever we are using materilized views automTically stored data into database or hord disk
2.we can perfor dml on simple views where as on materilized views we can not perform dmlX
3.in simplssviews having same roads of base table where as mview having different rowids when ever we are using refresh.
4.normal views get leatestdta where as mviewedoes not get latest data
Jan 3, 2019, 12:24:16 PM
Posted to Difference between View and Materialized View in Database or SQL? [Answer]