![]() Previous |
![]() Next |
The ISINFINITE function returns a value that indicates if a the value of a numeric expression is infinity.
See also: This function provides information similar provided by the SQL IS [NOT] INFINITE floating point condition as described in Oracle Database SQL Language Reference. |
Return Value
BOOLEAN
Returns TRUE
when the expression is either +INF (or -INF when NOT
is not specified); otherwise it returns FALSE
.
Note: The OLAP DML converts+INF or -INF values to NA when it performs calculation. Consequently, this function can only possibly return TRUE when executed against data that has been imported into an analytic workspace from a SQL-populated database but not yet used in an OLAP DML calculation. |
Syntax
ISINFINITE(expression)
Parameters
A decimal expression.