This article is written about how to use the Oracle/PLSQL BITAND function with syntax and examples.
Description
The Oracle/PLSQL BITAND function returns an integer representing an AND operation on the bits of expr1 and expr2.
Syntax
The syntax for the BITAND function in Oracle/PLSQL is:
bitand( expr1, expr2 )Parameters or Arguments
expr1 and expr2
Values that must resolve to non-negative integers.
Returns
The BITAND function returns an integer value.
Applies To
The BITAND function can be used in the following versions of Oracle/PLSQL:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example
Let’s look at some Oracle BITAND function examples and explore how to use the BITAND function in Oracle/PLSQL.
For example:
BITAND(5,3)
Result: 1
BITAND(15,7)
Result: 7
BITAND(5,2)
Result: 0
BITAND(5,0)
Result: 0
BITAND(6,2)
Result: 2