Moves the selected view column in the View Columns list box up one position.The Select tab is used in the Oracle Materialized Views Editor and the Oracle Views Editor. Use the Select tab to specify materialized view columns or view columns. You can create materialized view column or view column references to any table, view, or materialized view column in your model. By default the materialized view column or view column name reflects the column name that the materialized view or view references, but you can change the name of the materialized view column or view column. You can also reorder materialized view columns or view columns.
The following describes the options for the Select tab in the Oracle Materialized Views Editor:
Contains tables such as global temporary tables and external tables.
Contains the materialized view columns from the model.
Select one of the following options:
When you click on a column name from the Materialized View Columns list, it is automatically placed into the Alias field.
Edit the selected materialized view column expression. Available only if the selected view column is a user-defined expression.
Select New to open the New Materialized View Column dialog to create a New Alias and Expression.
Deletes the Alias and Expression.
The following describes the options for the Select tab in the Oracle Views Editor:
Contains tables such as global temporary tables and external tables.
A list box that contains the View columns from the model.
Moves the selected view column in the View Columns list box up one position.
Moves the selected view column in the View Columns list box down one position.
Moves the selected object from the Available Tables/Views/Materialized Views list box to the View Columns list box.
Moves the selected object from the View Columns list box to the Available Tables/Views/Materialized Views list box.
Moves all objects from the Available Tables/Views/Materialized Views list box to the View Columns list box.
Moves all objects from the View Columns list box to the Available Tables/Views/Materialized Views list box.
Select one of the following options:
When you click on a column name from the View Columns list, it is automatically placed into the Alias field. If there are constraints, and you delete the Alias, it returns an error. Aliases are required if constraints are used, so there cannot be blanks or NULL in the Alias field. Alias syntax is not generated if none of the Aliases were changed. However, if constraints are entered, aliases are generated. See also the options for the Constraints tab in the Oracle Views Editor.
Edit the selected view column expression. Available only if the selected view column is a user-defined expression.
Select the New button to open the New View Column dialog to create a New Alias and Expression.
Deletes the Alias and Expression.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |