Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test_bool_number (
    test_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
    abool NUMBER(1) CHECK (abool IN (0, 1)),
    bbool NUMBER(1) CHECK (bbool IN (0, 1)),
    PRIMARY KEY(test_id)
);
INSERT INTO test_bool_number (abool, bbool)
            select 0 AS a, 0 AS b from dual
  union all select 0, 1 from dual
  union all select 1, 0 from dual
  union all select 1, 1 from dual;
4 rows affected

SELECT abool,
       bbool,
       BITAND(abool, bbool),
       BITOR(abool, bbool)
FROM   test_bool_number
ORDER BY test_id;


ABOOL
BBOOL
BITAND(ABOOL,BBOOL)
BITOR(ABOOL,BBOOL)


0
0
0
0

0
1
0
1

1
0
0
1

1
1
1
1