PPT Slide

Using the sign( ) function

in SELECT statements:

sign( ) assists in identifying a number

to be positive or negative. If the number

passed is positive, sign( ) returns 1, and if

the number is negative, sign( ) returns –1.

If the number is zero, sign( ) returns zero:

SELECT SIGN(-1933),

SIGN(55),

SIGN(0)

FROM DUAL;SIGN(-1933) SIGN(55) SIGN(0)---------- ----------- --------1 1 0

36

Previous slide

Next slide

Back to first slide

View graphic version