The #1 Website for Oracle PL/SQL, OA Framework and HTML
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”
The ATAN2 function in Oracle SQL / PLSQL is used to get arc tangent of a n and m.
Syntax for the ATAN2 function in Oracle SQL / PLSQL is:
SELECT ATAN2(N,M)
FROM table_name;
N and M are the numbers which are used to calculate the arc tangents.
Example 1:
SELECT ATAN2(0.4,0.6) FROM DUAL;
Will return “0.588002603547568”
Example 2:
SELECT ATAN2(0,1) FROM DUAL;
Will return “0”
Example 3:
SELECT ATAN2(-0.4,0.4) FROM DUAL;
Will return “-0.785398163397448”
Example 4:
SELECT ATAN2(-0.4,-0.4) FROM DUAL;
Will return “-2.35619449019234”
The ATAN function in Oracle SQL / PLSQL is used to get arc tangent of a number.
Syntax for the ATAN function in Oracle SQL / PLSQL is:
SELECT ATAN(N)
FROM table;
N is the number whose arc tangent is to be determined.
Example 1:
SELECT ATAN(0.4) FROM DUAL;
Will return “0.380506377112365”
Example 2:
SELECT ATAN(0) FROM DUAL;
Will return “0”
Example 3:
SELECT ATAN(-0.4) FROM DUAL;
Will return “-0.380506377112365”
The ACOS function in Oracle SQL / PLSQL is used to get arc cosine of a number.
Syntax for the ACOS function in Oracle SQL / PLSQL is:
SELECT ACOS(N)
FROM table_name;
N is the number whose arc cosine is to be determined.
Example 1:
SELECT ACOS(0.4) FROM DUAL;
Will return “1.15927948072741”
Example 2:
SELECT ACOS(0) FROM DUAL;
Will return “1.5707963267949”
Example 3:
SELECT ACOS(-0.4) FROM DUAL;
Will return “1.98231317286238”
The ASIN function in Oracle SQL / PLSQL is used to get arc sine of a number.
Syntax for the ASIN function in Oracle SQL / PLSQL is:
SELECT ASIN(N)
FROM table;
N is the number whose arc sine is to be determined.
Example 1:
SELECT ASIN(0.4) FROM DUAL;
Will return “0.411516846067488”
Example 2:
SELECT ASIN(0) FROM DUAL;
Will return “0”
Example 3:
SELECT ASIN(-0.4) FROM DUAL;
Will return “-0.411516846067488”