1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Testing and Transforming Data
  6. Performing Tests
  7. Using @EVAL

Using @EVAL

Use @EVAL to select a value based on a series of independent conditional tests. 

@EVAL (AMOUNT > 10000, 'high amount', AMOUNT > 5000, 'somewhat high')

This example returns the following:

  • high amount if AMOUNT is greater than 10000

  • somewhat high if AMOUNT is greater than 5000, and less than or equal to 10000, (unless the prior condition was satisfied)

  • A FIELD_MISSING indication if neither condition is satisfied.