The Where tab is used in the Oracle Materialized Views Editor and the Oracle Views Editor. Use the Where tab to specify the search conditions and criteria to use when you generate the SQL code for the materialized view or view. The following describes the options for this tab:
Enter the condition that you want materialized view or view rows to satisfy in the Where box. You do not have to enter the WHERE keyword. The text you enter becomes the WHERE clause in the SQL code that is generated for the selected materialized view or view.
Enter the criteria on which you want to group either materialized view rows or view rows.
Optionally, enter a search condition in the Having box that is applied to each row group and filters out row groups that do not match the search condition from the query results.
Enter the criteria on which you want to sort the rows returned by the materialized view or view. The text you enter becomes the ORDER BY clause in the SQL code that is generated for the selected materialized view or view.
Enter the hierarchical order criteria on which you want to sort the rows returned by the materialized view or view.
Additionally, the Where tab in the Oracle Views Editor contains the following options:
Select one of the following options:
If you select this option, then the Constraints tab becomes disabled.
Indicate that a row must satisfy the constraint you enter in the Constraint Name box before the row is inserted into the view, or before the view is updated.
Enter a constraint name in the text box.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |