Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

Part Number E17122-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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.