Oracle BITAND function.

Preamble

The Oracle/PLSQL BITAND function returns an integer number representing the bitwise operation AND over the bits expr1 and expr2.

Oracle/PLSQL syntax of the BITAND function

bitand( expr1_id, expr2_id )

Parameters and function arguments

• expr1_id and expr2_id – must be non-negative integers.

The BITAND function returns integer value.

The BITAND function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the BITAND function and learn how to use the BITAND function in Oracle/PLSQL.

SELECT BITAND(5,3) FROM DUAL;

--Result: 1

SELECT BITAND(15,7) FROM DUAL;

--Result: 7

SELECT BITAND(5,2) FROM DUAL;

--Result: 0

SELECT BITAND(5,0) FROM DUAL;

--Result: 0

SELECT BITAND(6,2) FROM DUAL;

--Result: 2

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​