• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / LN Function in Oracle SQL – PLSQL

LN Function in Oracle SQL – PLSQL

November 5, 2012 by techhoneyadmin

The LN (natural log) function in Oracle SQL / PLSQL is used to return the natural logarithmic value of a number.

Syntax for the LOG function in Oracle SQL / PLSQL is:

SELECT LN(n)
FROM table_name;

n must be a positive number

Example 1:

SELECT LN(20)
FROM DUAL;

Will return “2.99573227355399”


Example 2:

SELECT LN(1)
FROM DUAL; 

Will return “0”


Filed Under: function Tagged With: how to use ln (natural log) function in oracle database query, how to use ln (natural log) function in oracle plsql, how to use ln (natural log) function in oracle sql, ln (natural log) function in oracle plsql, ln (natural log) function in oracle sql, LNPLSQL, syntax and example of ln (natural log) function in oracle database query, syntax and example of ln (natural log) function in oracle plsql, syntax and example of ln (natural log) function in oracle sql, using ln (natural log) function in oracle database query, using ln (natural log) function in oracle plsql, using ln (natural log) function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in