PLSQL | LN Function

The LN function is an inbuilt function in PLSQL which is used to return the natural logarithm of a given input number. The natural logarithm of a number is the logarithm of that number to the base e, where e is the mathematical constant approximately equal to 2.718. This is written using the notation lnx and also some time as logex.

Syntax:

LN(number) 

Parameters Used:
This function accept a parameter number which is the numeric value used to calculate the natural logarithm. This number should must be greater than 0.



Return Value:
This function returns the natural logarithm of a given input numeric value.

Supported Versions of Oracle/PLSQL:

  1. Oracle 12c
  2. Oracle 11g
  3. Oracle 10g
  4. Oracle 9i
  5. Oracle 8i

Let’s see some examples which illustrate the LN function:

Example-1:

DECLARE 
   Test_Number number := 20;
   
BEGIN 
   dbms_output.put_line(LN(Test_Number number)); 
   
END;  

Output:

2.99573227355399

In the above example, 20 is the numeric value whose natural logarithm value is 2.99573227355399

Example-2:

DECLARE 
   Test_Number number := 25;
   
BEGIN 
   dbms_output.put_line(LN(Test_Number number)); 
   
END; 

Output:

3.2188758248682

In the above example, 25 is the numeric value whose natural logarithm value is 3.2188758248682

Example-3:

DECLARE 
   Test_Number number := 100.5;
   
BEGIN 
   dbms_output.put_line(LN(Test_Number number)); 
   
END; 

Output:

4.61015772749913

In the above example, 100.5 is the numeric value whose natural logarithm value is 4.61015772749913

Advantage:
This function is used to find out the natural logarithm of a given input number.



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.