Oracle SQL - Function EXP function

Introduction

EXP - Returns e raised to a value.

Demo

SQL>
SQL> drop table my_table;

Table dropped.-- from w  w  w  . ja va 2  s.com

SQL> CREATE TABLE my_table (
  2      LINENO NUMBER(2) not null,
  3      VALUE NUMBER(6,2) not null
  4  );
SQL>
SQL> insert into my_table values(1,1.2);
SQL> insert into my_table values(2,123.34);
SQL> insert into my_table values(3,-12.2);
SQL> insert into my_table values(4,100);
SQL> insert into my_table values(5,48);
SQL> insert into my_table values(6,-90);
SQL> insert into my_table values(7,0.19);
SQL> SELECT EXP(value)
  2  FROM my_table;

EXP(VALUE)
----------
  00003.32
 #########
  00000.00
 #########
 #########
  00000.00
  00001.21

7 rows selected.

SQL>