The SIGN function in Oracle SQL / PLSQL is used to get a value which indicates the sign of a number.
Syntax for the SIGN function in Oracle SQL / PLSQL is:
SELECT SIGN(N)
FROM table_name;
- N is the number whose SIGN is to be determined.
- If N >0 then 1 is returned
- If N = 0 then 0 is returned
- If N< 0 then -1 is returned
Example 1:
1 | SELECT SIGN(1.23456) |
2 | FROM DUAL; |
Will return “1”
Example 2:
1 | SELECT SIGN(0) |
2 | FROM DUAL; |
Will return “0”
Example 3:
1 | SELECT SIGN(-2.051) |
2 | FROM DUAL; |
Will return “-1”