Materialised View In Oracle. Add fields to the record, and insert the sql query using the query editor. Unike a materialized view, a view is always constructed at runtime, and the tables and joined and aggregations made every time the view is invoked.

You need special privileges or roles to query this view like the system privilege select any dictionary or the role select_catalog_role. Use the create materialized view statement to create a materialized view.a materialized view is a database object that contains the results of a query. Select the record type tab.