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”