Search notes:

Oracle SQL function: BITAND

select
   bitand(bin_to_num(1, 1, 1, 0, 1, 0),
          bin_to_num(1, 0, 1, 0, 0, 1)) anded
from
   dual;

There is no built-in BITOR function in Oracle; the or-value of two numbers a and b can be simulated with a - bitand(a,b) + b, for example for 33 and 5:

select
   33 - bitand(33, 5) + 5     orred
from
   dual;

Oracle SQL function: BITAND

See also