Oracle SQL - Function LN function

  1. HOME
  2. Oracle SQL
  3. Function
  4. LN function

Introduction

LN Returns natural logs, that is, logs with respect to base e.

Demo

SQL>
SQL>-- from  ww  w  .  j a  v  a  2  s .c o m
SQL> drop table my_table;

Table dropped.

SQL> CREATE TABLE my_table (
  2      LINENO NUMBER(2) not null,
  3      VALUE NUMBER(6,2) not null
  4  );
SQL>
SQL> insert into my_table values(1,1.2);
SQL> insert into my_table values(2,123.34);
SQL> insert into my_table values(3,-12.2);
SQL> insert into my_table values(4,100);
SQL> insert into my_table values(5,48);
SQL> insert into my_table values(6,-90);
SQL> insert into my_table values(7,0.19);
SQL> SELECT LN(value)
  2  FROM my_table ;
ERROR:
ORA-01428: argument '-12.2' is out of range



no rows selected

SQL>