Data Compare for Oracle 5

Filtering the comparison with a WHERE clause

You can filter the rows that will be compared by applying a WHERE clause to the comparison. This is useful, for example, if you want to exclude a particular set of test data, or to speed up the comparison.

  • You can only filter rows if the data source is a database. WHERE clauses are not available for scripts folders
  • The WHERE Clause Editor doesn't validate WHERE clauses. The clauses are validated when the databases are compared.

To specify a WHERE clause for a table:

  1. On the Tables tab, double click the table you want to filter, or select it and click WHERE Clause.
    The WHERE Clause Editor is displayed:

    To apply the same WHERE clause to multiple tables, use SHIFT+Click or CTRL+Click.
  2. Type a valid WHERE clause. For example, if a table has columns ID, FirstName, and LastName, you may want to compare only rows where LastName is Smith. To do this, type the following in the box:


    If you want to apply a different WHERE clause for each data source, clear the Use the same WHERE clause for both data sources check box and type a WHERE clause in the box for the target database.

  3. Click OK. An icon ( ) is displayed next to any tables that will be filtered.

Didn't find what you were looking for?