Oracle PL/SQL Materialized Views

Materialized View A materialized view whose contents are periodically refreshed based on a query, either against a local or remote table. fig 1 represents materialized view logic flow CREATE MATERIALIZED VIEW view-name BUILD [IMMEDIATE | DEFERRED] R...