BITAND
BITAND(x,y)
performs a bitwise AND on x and y.
SQL> select BITAND(0, 0) from dual;
BITAND(0,0)
-----------
0
SQL> select BITAND(0, 1) from dual;
BITAND(0,1)
-----------
0
SQL> select BITAND(1, 0) from dual;
BITAND(1,0)
-----------
0
SQL> select BITAND(1, 1) from dual;
BITAND(1,1)
-----------
1
SQL> select BITAND(1010, 1100) from dual;
BITAND(1010,1100)
-----------------
64
SQL>