Previous Topic: Select the Source for a Materialized ViewNext Topic: Specify a Search Condition for a Materialized View


Specify an Alias for a Materialized View Source

To specify an alias for a materialized view source

  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 opens with additional options.

  2. Click the From option on the context menu.

    The Materialized Views Editor opens on the From tab.

  3. Select a table, view, or materialized view from the From list.
  4. Enter the name that you want to use as an alias for the selected table, view, or materialized view in the Alias box.
  5. Click OK.

More information:

Oracle Editors - From Tab