top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What is the output of SIGN function?

+2 votes
366 views
Oracle: What is the output of SIGN function?
posted Mar 19, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Sign operation returns 1 for the positive integer and -1 for negative integer.

Select sign(24),sign(-24) from dual;

Output 
1  -1
answer Mar 20, 2015 by Santosh Kumar Panigrahi
...