IS NAN : New for Oracle10g. Matches the NaN special value, which means "not a number"
IS INFINITE : New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values
You can also use the NOT operator to reverse the meaning
IS NOT NAN
IS NOT INFINITE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment