Name

SIGN

Synopsis

The SIGN function returns the sign of the input number. The specification for the SIGN function is:

FUNCTION SIGN (n NUMBER) RETURN NUMBER;

This function returns one of these three values:

-1

n is less than zero

0

n is equal to zero

+1

n is greater than zero

Get Oracle PL/SQL Programming, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.