w3resource

Oracle EXP() function

Description

The Oracle EXP() function is used to get the value of the base of natural logarithm number e, raised to the power of a number specified as argument, where e ≈ 2.71828183.
The function takes any numeric or nonnumeric data type (can be implicitly converted to a numeric data type) as an argument.
If the argument is BINARY_FLOAT, then the function returns BINARY_DOUBLE. Otherwise, the function returns the same numeric data type as the argument.

Uses of Oracle EXP() Function
  • Exponential Calculations: Compute the exponential value of a given number.

  • Mathematical Operations: Utilize in mathematical formulas requiring the exponential function.

  • Scientific Research: Apply the exponential function in scientific studies and experiments.

  • Financial Analysis: Perform exponential growth calculations in financial models.

  • Data Analysis: Conduct exponential transformations in data analysis.

  • Engineering Applications: Use in various engineering fields for exponential operations.

Syntax:

EXP(N);

Parameters:

Name Description
N A number.

Pictorial Presentation of EXP() function

Pictorial Presentation of Oracle EXP() function

Example:

The statement below will return the value of the natural logarithm base number e raised to the power of the number 1.

SELECT EXP(1) FROM dual;

Here is the result.

    EXP(1)
----------
2.71828183

Example: EXP() function with negative value

The statement below will return the value of the natural logarithm base number e raised to the power of the number -1.

SELECT EXP(-1) FROM dual;

Here is the result.

   EXP(-1)
----------
.367879441

Previous: COSH
Next: FLOOR



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/oracle/oracle-numeric-functions/oracle-exp-function.php