Tech Honey

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

BITAND Function in Oracle SQL – PLSQL

by

The BITAND function in Oracle SQL / PLSQL is used to return an integer number representing an AND operation between the bits of expressions passed.

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

SELECT BITAND(expression1, expression2)
FROM table_name;

Expression1 and expression2 must resolve to positive integers

Example 1:

SELECT BITAND(20,10)
FROM DUAL;

Will return “0”

Example 2:

SELECT BITAND(20,30)
FROM DUAL;

Will return “20”

LN Function in Oracle SQL – PLSQL

by

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”

ATAN2 Function in Oracle SQL – PLSQL

by

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”

ATAN Function in Oracle SQL – PLSQL

by

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”

ACOS Function in Oracle SQL – PLSQL

by

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”