OGG 行过滤filter 参数

最新推荐文章于 2024-02-23 16:48:16 发布

转载最新推荐文章于 2024-02-23 16:48:16 发布 · 1.5k 阅读

收录于

本文详细介绍了如何使用FILTER表达式在数据中选择或排除基于数值的记录，包括数值、包含数值的列、返回数值的函数、算术运算符和比较运算符的应用。通过实例展示了如何利用FILTER进行复杂的数据筛选。

Using FILTER
Use FILTER to select or exclude records based on a numeric value. A filter expression can use
conditional operators, Oracle GoldenGatecolumn-conversion functions, or both
filter 参数基于数值来选择或者提出数据！！！-----最重要
Separate all FILTERcomponents with commas. A FILTERclause can include the following:
● 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)
= (equal)
<> (not equal)
Results derived from comparisons can be zero (indicating FALSE) or non-zero (indicating
TRUE).
● Parentheses (for grouping results in the expression)
● Conjunction operators: AND, OR
FILTER ((PRODUCT_PRICE*PRODUCT_AMOUNT)>10000))
FILTER (@STRFIND(NAME, "JOE") > 0) @STRFIND--字符函数

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26764973/viewspace-1194950/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26764973/viewspace-1194950/