Oracle EXP function.

Preamble

Oracle/PLSQL EXP function returns e elevated to n-th degree where e = 2.71828183.

Oracle/PLSQL syntax of the EXP function

exp( number_id )

Parameters and function arguments

• number_id – the degree to which e. is elevated.

The EXP function returns a numeric value.

EXP function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of EXP function and learn how to use EXP function in Oracle/PLSQL.

SELECT EXP(3) FROM DUAL;

--Result: 20.0855369

SELECT EXP(3.1) FROM DUAL;

--Result: 22,1979512

SELECT EXP(-3) FROM DUAL;

--Result: 0.04978706

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​