1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Selecting and Filtering Rows
  6. Selecting Rows with a WHERE Clause

Selecting Rows with a WHERE Clause

Use any of the elements described in the table below in a WHERE clause to select or exclude rows (or both) based on a conditional statement. Each WHERE clause must be enclosed within parentheses. Literals must be enclosed within single quotes.

Table 8-4 Permissible WHERE Operators

Element Examples

Column names

 
PRODUCT_AMT

Numeric values

 
-123, 5500.123

Literal strings

 
'AUTO', 'Ca'

Built-in column tests

@NULL, @PRESENT, @ABSENT (column is null, present or absent in the row). These tests are built into Oracle GoldenGate. See Considerations for Selecting Rows with FILTER and WHERE.

Comparison operators

=, <>, >, <, >=, <=

Conjunctive operators

 
AND, OR

Grouping parentheses

Use open and close parentheses ( ) for logical grouping of multiple elements.

Oracle GoldenGate does not support FILTER for columns that have a multi-byte character set or a character set that is incompatible with the character set of the local operating system.

Arithmetic operators and floating-point data types are not supported by WHERE. To use more complex selection conditions, use a FILTER clause or a user exit routine. See Using User Exits to Extend Oracle GoldenGate Capabilities for more information.

The syntax for WHERE is identical in the TABLE and MAP statements: 

TABLE table, WHERE (clause);

MAP source_table, TARGET target_table, WHERE (clause);