what is materialized views in oracle?

What are materialized views in Oracle? Privileges required to create materialized view User must have CREATE MATERIALIZED VIEW to create materialized view General Syntax CREATE MATERIALIZED VIEW BUILD [IMMEDIATE | DEFERRED] REFRESH [FAST | COMPLETE | FORCE ] ON [COMMIT | DEMAND ] [[ENABLE | DISABLE] QUERY REWRITE] [ON PREBUILT TABLE] AS ; Explanation of each term …

what is materialized views in oracle? Read More »