tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

Oracle/PLSQL: SIGN Function

Learn how to use the Oracle/PLSQL SIGN function with syntax and examples.

Description

The Oracle/PLSQL SIGN function returns a value indicating the sign of a number.

Syntax

The syntax for the Oracle/PLSQL SIGN function is:

SIGN( number )

Parameters or Arguments

number is the number to test for its sign.

Note

If number < 0, then sign returns -1.

If number = 0, then sign returns 0.

If number > 0, then sign returns 1.

Applies To

The SIGN function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example

Let's look at some Oracle SIGN function examples and explore how to use the SIGN function in Oracle/PLSQL.

For example:

SIGN(-23) would return -1
SIGN(-0.001) would return -1
SIGN(0) would return 0
SIGN(0.001) would return 1
SIGN(23) would return 1
SIGN(23.601) would return 1