To perform the numeric function in simple database table

Experiment-07

Object: To perform the numeric function in simple database table.

Requirement: Windows XP, Oracle 9i.

Program Code And Output :

SQL> select abs(-90) from dual;

 ABS(-90)

---------

      90

SQL> select floor(9227.97) from dual;

FLOOR(9227.97)

--------------

          9227

SQL> select ceil(9227.97) from dual;

CEIL(9227.97)

-------------

         9228

SQL> select mod(60,7) from dual;

MOD(60,7)

---------

        4

SQL> select power(3,2) from dual;

POWER(3,2)

----------

         9

SQL> select round(15.19,1) from dual;

ROUND(15.19,1)

--------------

          15.2

SQL> select sqrt(25) from dual;

 SQRT(25)

---------

        5

SQL> select exp(5) from dual;

 EXP(5)

---------

148.41316

SQL> select greatest(4,5,17) from dual;

GREATEST(4,5,17)

----------------

              17

SQL> select least(4,5,17) from dual;

LEAST(4,5,17)

-------------

            4

Result:The above mathematical functions has been successfully executed.