Floor function Oracle

Floor function returns previous whole number. It is a Numeric Function.

Syntax :-

FLOOR(n) where n is a number

Examples :-

SQL> select floor(1.1) from dual;

FLOOR(1.1)
———-
1

SQL> select floor(1) from dual;

FLOOR(1)
———-
1

SQL> select floor(-1.1) from dual;

FLOOR(-1.1)
———–
-2

SQL> select floor(-1) from dual;

FLOOR(-1)
———-
-1

SQL> select floor(0) from dual;

FLOOR(0)
———-
0

About these ads

About sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated.
This entry was posted in Oracle and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s