sign函数的功能oracle,Oracle函数——SIGN函数

第一次看到oracle中的SIGN函数，感觉可用于简化SQL语句。

Syntax

Purpose

SIGN returns the sign of n. This function takes as an argument any numeric data type,

or any nonnumeric data type that can be implicitly converted to NUMBER, and returns

NUMBER.

For value of NUMBER type, the sign is:

■ -1 if n<0

■ 0 if n=0

■ 1 if n>0

For binary floating-point numbers (BINARY_FLOAT and BINARY_DOUBLE), this function

returns the sign bit of the number. The sign bit is:

■ -1 if n<0

■ +1 if n>=0 or n=NaN

Examples

The following example indicates that the argument of the function (-15) is <0:

SELECT SIGN(-15) "Sign" FROM DUAL;

Sign

----------

-1