Skip Headers
Oracle® Database SQL Reference
10g Release 2 (10.2)

Part Number B14200-02
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
PDF · Mobi · ePub

Floating-Point Conditions

The floating-point conditions let you determine whether an expression is infinite or is the undefined result of an operation (that is, is not a number or NaN).

floating_point_conditions::=

Description of floating_point_conditions.gif follows
Description of the illustration floating_point_conditions.gif

In both forms of floating-point condition, expr must resolve to a numeric datatype or to any datatype that can be implicitly converted to a numeric datatype. Table 7-3 describes the floating-point conditions.

Table 7-3 Floating-Point Conditions

Type of Condition Operation Example
IS [NOT] NAN

Returns TRUE if expr is the special value NaN when NOT is not specified. Returns TRUE if expr is not the special value NaN when NOT is specified.

SELECT COUNT(*) FROM employees
  WHERE commission_pct IS NOT NAN;
IS [NOT] INFINITE

Returns TRUE if expr is the special value +INF or -INF when NOT is not specified. Returns TRUE if expr is neither +INF nor -INF when NOT is specified.

SELECT last_name FROM employees
  WHERE salary IS NOT INFINITE;

See Also: