ISINFINITE

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

expression: A decimal expression.