BITAND

Computes an AND operation on the bits of expression1 and expression2.

SQL syntax

BITAND (Expression1, Expression2)

Parameters

BITAND has the following parameters:

Parameter	Description
Expression1 Expression2	AND operation computed on the bits of Expression1 and Expression2.

Description

• This function returns TT_INTEGER NOT NULL.

• The BITAND function is rewritten into (expression1 & expression2). See the bitwise AND operator for more information.

• The AND operation compares two bit values. If the values are the same, the operator returns 1. If the values are different, the operator returns 0.

Examples

Use the BITAND function to return the result of the bitwise AND (&) operation on two expressions.

Command> SELECT BITAND (1,2) FROM dual;
< 0 >
1 row found.