Oracle Built In Functions:FLOOR function

In Oracle PL/SQL FLOOR function Returns largest integer equal to or less than num.

Syntax

FLOOR(NUM)

Example

SELECT FLOOR(24.7) “Floor” FROM DUAL;

Floor
———-
24

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .

Identification

Article search

Sections

Oracle Administration (6.13.2010)
- Introduction to DataBase Administration (8.14.2010)
- Types of Oracle Database users (8.14.2010)
Oracle Backup and Recovery (6.13.2010)
- Oracle Backup:Basic concepts (8.15.2010)
- Oracle Recovery:Basic Concepts (8.15.2010)
Oracle PL/SQL (6.13.2010)
- ASCII Function in PL/SQL (6.19.2010)
- Oracle PL/SQL:Built In Exceptions (7.15.2010)
- PL/SQL:CASE Statement (7.15.2010)
- Character Functions in PL/SQL (6.19.2010)
- Comments in PL/SQL (6.18.2010)
- Conditional Control Statments (7.15.2010)
- Cursor FOR Loop (7.26.2010)
- Oracle PL/SQL:Data Types (7.15.2010)
- Oracle PL/SQL:Constants (7.15.2010)
- Oracle PL/SQL :Declaring Variables (7.15.2010)
- Delimiters (6.17.2010)
- EXIT Statement in PL/SQL (7.22.2010)
- EXIT-WHEN statement in PL SQL (7.22.2010)
- FOR Loop in Oracle PL SQL (7.26.2010)
- Fundementals of PL/SQL (6.15.2010)
  - Declarations (6.17.2010)
- PL/SQL:GOTO Statement (7.18.2010)
- Identifiers (6.16.2010)
- Identifiers(contd..) (6.16.2010)
- Oracle PL/SQL:IF-THEN-ELSE Statment (7.15.2010)
- INSTRC Function in PL/SQL (6.19.2010)
- Introduction to PL/SQL (6.13.2010)
- Lexical Units (6.15.2010)
- Loop statement In PL SQL (7.22.2010)
- Loops in Oracle PL SQL (7.20.2010)
- NLS_LOWER Function in PL/SQL (6.20.2010)
- Oracle Built In Functions:ACOS function (7.10.2010)
- Oracle Built In Functions:ADD_MONTHS Function (7.10.2010)
- Oracle Built In Functions:ATAN function (7.10.2010)
- Oracle Built in Functions:ATAN2 function (7.10.2010)
- Oracle Built in Functions:AVG function (7.10.2010)
- Oracle Built In Functions:CEIL function (7.10.2010)
- Oracle Built In Functions:EXP function (7.10.2010)
- Oracle Built In Functions:FLOOR function (7.10.2010)
- Oracle Built In Functions:LN function (7.10.2010)
- Oracle Built In Functions:MOD function (7.10.2010)
- Oracle Built In Functions:Numeric Functions (7.10.2010)
- Oracle Built In Functions:SIGN Function (7.10.2010)
- Oracle Built In Functions:SIN function (7.10.2010)
- Oracle Built In Functions:SINH function (7.10.2010)
- Oracle Built In Functions:SQRT function (7.10.2010)
- Oracle Built In Functions:TAN function (7.10.2010)
- Oracle Built in Functions:LOG function (7.10.2010)
- PL/SQL Built-in Functions (6.19.2010)
- PL/SQL Character Set (6.15.2010)
- RETURN Statement in PL SQL (7.22.2010)
- Sequential Control Statements (7.18.2010)
- Oracle PL/SQL:Stored Functions (7.15.2010)
- Oracle PL/SQL:Stored Procedures (7.15.2010)
- Oracle Pl/SQL Stored Procedures:Procedure Parameters (7.15.2010)
- Stored Procedures:Advanced Concepts (7.15.2010)
- WHILE Loop in Oracle PL SQL (7.27.2010)
Oracle Database Tuning (6.13.2010)
- SQL Tuning Tips-Identify Bad SQL Statements (8.12.2010)
Partners (8.4.2010)
Oracle SQL * Plus (6.13.2010)
- Introduction to SQL (7.12.2010)
- Introduction to SQL* Plus (8.2.2010)
- SQL Select Statement (8.8.2010)
- Script Files in SQL * Plus (8.3.2010)
- SQL * Plus Editing Commands (8.2.2010)
About Us (6.16.2010)

Last articles

Partitioning in oracle (3.26.2011)
Using SQL statements in C (2.15.2011)
UTL_FILE_DIR in Oracle (1.28.2011)
Use DECODE for IF/ELSE Selection (1.27.2011)
DBMS_ALERT Package (1.19.2011)
Oracle 11g:Automatic Storage Management (1.1.2011)
Using SQL Trace in oracle (12.29.2010)
Exception Handling in Oracle PL/SQL (12.21.2010)
Relational Database Management System(RDBMS) (12.21.2010)
Pseudocolumns in SQL (12.18.2010)

Monthly archives

Favourite sites

Subscribe to this site

Stay current with Techno Oracle on these personalized pages: