The Oracle Bitand () function uses

the Oracle bitand () function Oracle database is very common, here is a detailed description of the use of the Oracle Bitand () function, if you are interested, may wish to see.

Oracle Bitand () function:

Returns the result of two numeric numeric values after a bitwise AND operation.
Grammar
Bitand (NExpression1, NExpression2)
Parameters
NExpression1, NExpression2

Specifies the two numeric values for the bitwise AND operation. If NExpression1 and NExpression2 are non-integer, they are converted to integers before the bitwise AND operation.
The Oracle Bitand () function returns a value type:
Numeric type
Description
Bitand () compares each bit of nExpression1 with the corresponding bit of nExpression2. If the bits of NExpression1 and NExpression2 are both 1, the corresponding result bit is 1; otherwise the corresponding result bit is 0.

Bitand () Function Example
x = 5&& binary is 0101
y = 6&& binary is 0110
Bitand (x, y) && return value 4, binary 0100