Difference of view.

MVIEW is like a regular view with the exception that it has a table like structure. You say it is a table created from a sql. MV requires refresh to get the latest data, it is basically a SNAPSHOT of data in time it is not real time. Regular view(RV) has to table like structure, it is an object created from a sql but only in definition it does not hold data like a table. RV does not require refresh, every time u select from an RV the data is real time. Regards Ashutosh (Oracle Dba)

View is just another view for table data, it is not exactly a physical object, it is just a logical object. Whereas materialized view is a snapshot of table data at one particular time. Moreover Materialized View is a physical structure.

Both are logical objects. But view always shows the data of the tables joined to create the view. But MV requires to refresh every time to show the present data.