PL/SQL Sign

Oracle PL/SQL Sign Function

The Sign function returns a value indicating the sign of a number.

The Sign Function syntax:

sign( number )

Example

Select sign(-86) From dual;
-1

Select sign(86) From dual;
1

Select sign(-0.0034) From dual;
-1

Select sign(0.0034) From dual;
1

Select sign(0) From dual;
0