Oracle SIGN function.

Preamble

The Oracle/PLSQL SIGN function returns a value that defines a number sign.

The Oracle/PLSQL syntax of the SIGN function

SIGN( number_id )

Parameters and function arguments

• a number_id – to check for his sign.

Note:

• if number < 0, it will return -1.
• if number = 0, it will return 0.
• if number > 0, it will return -1.

SIGN function in the following versions of Oracle/PLSQL

Let’s look at some examples of the SIGN function and learn how to use the SIGN function in Oracle/PLSQL.

SELECT SIGN(-18) FROM DUAL;

--Result: -1

SELECT SIGN(-0.003) FROM DUAL;

--Result: -1

SELECT SIGN(0) FROM DUAL;

--Result: 0

SELECT SIGN(0.003) FROM DUAL;

--Result: 1

SELECT SIGN(18) FROM DUAL;

--Result: 1

SELECT SIGN(18.106) FROM DUAL;

--Result: 1

SQL SIGN function – how to use SQL SIGN function

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​