Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL LN Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: LN

Definition:
The Oracle PL/SQL LN function is used to get the natural logarithm (to the base e) of a number. It returns number output with numeric inputs and BINARY_DOUBLE with inputs of type BINARY_FLOAT.

Example Syntax:

LN(n)


n may be any legitimate numeric value or any datatype that can be implicitly converted to a numeric value. The LN function will return a value that is the same datatype as the argument provided unless the argument is a BINARY_FLOAT. If the argument is a BINARY_FLOAT then the LN function will return a BINARY_DOUBLE.

Example Usage:

SELECT LN(10) as res FROM DUAL;

RES
-------------------
2.30258509


SELECT LN(20) as res FROM DUAL;

RES
-------------------
2.99573227


Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 94 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?