Oracle PL/SQL/Numeric Math Functions/EXP

EXP(2)

   <source lang="sql">

SQL> select EXP(2) from dual;

   EXP(2)

---

7.3890561

SQL> SQL>

      </source>
   
  

EXP: Returns e raised to a value

   <source lang="sql">

SQL> SQL> -- create demo table SQL> create table TestTable(

 2    ID                 VARCHAR2(4 BYTE)         NOT NULL,
 3    MyName             VARCHAR2(10 BYTE),
 4    MyDate             DATE,
 5    MyNumber           Number(8,2)
 6  )
 7  /

Table created. SQL> SQL> SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19960711","YYYYMMDD"),12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19970622","YYYYMMDD"),-12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19980513","YYYYMMDD"),22.1); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19990624","YYYYMMDD"),-2.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("20000415","YYYYMMDD"),2.1); 1 row created. SQL> SQL> SQL> select * from TestTable

 2

SQL> SQL> --EXP: Returns e raised to a value. SQL> SELECT EXP(MyNumber) FROM TestTable; EXP(MYNUMBER)

---

  183505.515
  5.4494E-06
  3961941421
  .120031629
  8.16616991

SQL> SQL> drop table TestTable;

      </source>
   
  

EXP() returns e raised to the nth power (n is the <numeric_expression> value), where e is equal to approximately 2.71828183.

   <source lang="sql">

SQL> Syntax:EXP(<numeric expression>) SQL> SQL> SQL> SELECT

 2     EXP(10) exponent from dual;
 EXPONENT

---

22026.4658 SQL> SQL>

</source>
   
  

EXP(x):Returns the result of the number e raised to the power x

   <source lang="sql">

SQL> --EXP(x):Returns the result of the number e raised to the power x, --where e is approximately 2.71828183. SQL> SQL> select EXP(1) from dual;

   EXP(1)

---

2.71828183 SQL>

      </source>