Advanced Search

Return to Snippet

Revision: 71286
at February 7, 2017 08:26 by bbrumm
Initial Code 
/*
SIGN Examples
*/

--Example 1
SELECT SIGN(45) AS SIGN_VALUE
FROM dual;

--Example 2
SELECT SIGN(-3) AS SIGN_VALUE
FROM dual;


--Example 3
SELECT SIGN(0) AS SIGN_VALUE
FROM dual;


--Example 4
SELECT SIGN(0.198) AS SIGN_VALUE
FROM dual;


--Example 5
SELECT SIGN(493781.395) AS SIGN_VALUE
FROM dual;
Initial URL 
http://www.databasestar.com/oracle-sign/
Initial Description 
A few examples of the SIGN function
Initial Title 
Oracle SIGN Function
Initial Tags 
sql, Oracle
Initial Language 
SQL