SIGN

SIGN returns a value that indicates whether a specified number is less than, equal to, or greater than 0 (zero):

• -1 if n < 0
• 0 if n = 0
• 1 if n > 0

Return Value

NUMBER

Syntax

SIGN(n)

Arguments

n is a numeric expression.

Example

SIGN(-15) returns the value -1.00.

Copyright © 2003, 2007, Oracle. All rights reserved.