ogg中filter用法

最新推荐文章于 2023-06-19 13:05:25 发布

xiaoxiao树

最新推荐文章于 2023-06-19 13:05:25 发布

阅读量5.6k

点赞数

分类专栏： oracle ogg 文章标签： oracle goldengate

本文链接：https://blog.csdn.net/u010719917/article/details/78626484

版权

博客讨论了在Oracle GoldenGate中如何使用filter进行字符串类型的更新过滤。在ogg for MySQL中，filter可以成功应用在更新字符串上，但ogg for Oracle则需要特殊配置，如使用@before和@after函数结合动态分辨率来实现相同效果。

摘要由CSDN通过智能技术生成

官方资料对filter说明：

Valid FILTER clause elements are the following:
  ● An Oracle GoldenGate column-conversion function. These functions are built into
  Oracle GoldenGate so that you can perform tests, manipulate data, retrieve values,
  and so forth. For more information about Oracle GoldenGate conversion functions, see “Testing and transforming data” on page 253.
  ● Numbers
  ● Columns that contain numbers
  ● Functions that return numbers
  ● Arithmetic operators:
    + (plus)
    - (minus)
    * (multiply)
    / (divide)
    \ (remainder)
  ● Comparison operators:
    > (greater than)
    >= (greater than or equal)
    < (less than)
    <= (less than or equal)
    = (