Previous Topic: Specify an Alias for a Materialized View SourceNext Topic: Change the SQL Code for a Materialized View

Creating Models › Creating a Physical Model › Materialized Views › Specify a Search Condition for a Materialized View

Specify a Search Condition for a Materialized View

To specify a search condition for a materialized view

  1. In a physical model based on Oracle, right-click a materialized view in the diagram, and select Database Materialized View Properties.

    A context menu with additional options opens.

  2. Select the Where option from the context menu.

    The Views Editor opens on the Where tab.

  3. Enter the condition that you want materialized view rows to satisfy in the Where box. You do not have to enter the WHERE keyword. You can also enter conditions for the GROUP and HAVING clauses.
  4. Click OK.

More information:

Oracle Editors - Where Tab