BITAND Function in Oracle SQL – PLSQL

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”


Tagged , , , , , , , , , , , . Bookmark the permalink.