Posted By

bbrumm on 02/07/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/07/17 08:26am

Statistics

Viewed 732 times

Favorited by 0 user(s)

Related snippets

Oracle SIGN Function

/ Published in: SQL

A few examples of the SIGN function

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/*
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;