SQL Plus - What is the output of SIGN function

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 48 of 132

What is the output of SIGN function

Total Answers and Comments: 4

Last Update: March 23, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 29, 2005 11:44:09

harsha

RE: What is the output of SIGN function

SIGN (a): Returns 1 if a is positive or if a is 0 and -1 if a is less than 0.

Is this answer useful? Yes | No

December 07, 2006 06:47:20

rampratap409

Member Since: September 2006 Contribution: 111

RE: What is the output of SIGN function

1 or -1

Is this answer useful? Yes | No

March 29, 2007 06:29:09

qwe

RE: What is the output of SIGN function

SIGN (a): Returns 1 if a is positive -1 if a is less than 0 and 0 if a is 0

Is this answer useful? Yes | No

March 23, 2009 06:05:52

sharmasl

Member Since: March 2009 Contribution: 10

RE: What is the output of SIGN function

for - values it return (-1);
for 0 it return (0);
for + values it return (+1);

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank