Apps

How to Create Materialized View in Oracle Apps 12.2.5 (R12)

Materialized views are the database objects in Oracle based on SQL Queries. Unlike the normal view, MV actually contains the data. The generic statement to create a Materialize View is, CREATE MATERIALIZED VIEW viewname [options] AS SELECT ….. While working on Oracle Apps 12.2.5 where editioning or online patching is enabled, you need to use …

How to Create Materialized View in Oracle Apps 12.2.5 (R12) Read More »