Oracle PL/SQL Tutorial/Numerical Math Functions/EXP
EXP(1)
<source lang="sql">
SQL> select EXP(1) from dual;
EXP(1)
2.71828183</source>
EXP(2)
<source lang="sql">
SQL> select EXP(2) from dual;
EXP(2)
7.3890561</source>
Using the EXP function
<source lang="sql">
SQL> SQL> -- create demo table SQL> create table myTable(
2 id NUMBER(2), 3 value NUMBER(6,2) 4 ) 5 /
Table created. SQL> SQL> -- prepare data SQL> insert into myTable(ID, value)values (1,9)
2 /
1 row created. SQL> insert into myTable(ID, value)values (2,2.11)
2 /
1 row created. SQL> insert into myTable(ID, value)values (3,3.44)
2 /
1 row created. SQL> insert into myTable(ID, value)values (4,-4.21)
2 /
1 row created. SQL> insert into myTable(ID, value)values (5,10)
2 /
1 row created. SQL> insert into myTable(ID, value)values (6,3)
2 /
1 row created. SQL> insert into myTable(ID, value)values (7,-5.88)
2 /
1 row created. SQL> insert into myTable(ID, value)values (8,123.45)
2 /
1 row created. SQL> insert into myTable(ID, value)values (9,98.23)
2 /
1 row created. SQL> SQL> select * from myTable
2 / ID VALUE
----------
1 9 2 2.11 3 3.44 4 -4.21 5 10 6 3 7 -5.88 8 123.45 9 98.23
9 rows selected. SQL> SQL> SELECT EXP(value) FROM myTable
2 /
EXP(VALUE)
8103.08393 8.24824128 31.1869582 .014846368 22026.4658 20.0855369 .002794785 4.1082E+53 4.5788E+42 9 rows selected. SQL> SQL> -- clean the table SQL> drop table myTable
2 /
Table dropped. SQL></source>