1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Selecting and Filtering Rows
  6. Considerations for Selecting Rows with FILTER and WHERE
  7. Comparing Column Values

Comparing Column Values

To ensure that elements used in a comparison match, compare appropriate column types:

  • Character columns to literal strings.

  • Numeric columns to numeric values, which can include a sign and decimal point.

  • Date and time columns to literal strings, using the format in which the column is retrieved by the application.