If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

A view is a select statement stored in the data dictionary. Snapshots are now known as materialized views. A materialized view is a series of objects, including a table, that stores actual data in your schema.

Both a view and a materialized view start with a SELECT statement. In the view, there is nothing more. In the materialized view there is an optional timer to run the SELECT statement, and there is storage of data that resulted from the SELECT statement.

Views are therefore 100% dynamic. MVs are only as dynamic as your timer's frequency.