Passing a BYTEINT Value to BITAND
In the following query, the input argument 23 has a data type of BYTEINT and a binary representation of 00010111. The input argument 20 has a data type of BYTEINT and a binary representation of 00010100. The bitwise AND product of the two arguments results in a BYTEINT value of 20, or binary 00010100, which is returned by the query.
SELECT BITAND(23,20);
Passing a NUMBER Value to BITAND
SELECT BITAND( CAST('A593C38281B4D2E1'XI8 AS NUMBER), 'FFFFFFFFFFFFFFFF'xb);
Result:
BITAND(-6515649270585699615,'FFFFFFFFFFFFFFFF'XB)
-------------------------------------------------
-6515649270585699615
SELECT TO_BYTE( CAST( BITAND( CAST('5A393C28184B2D1E'XI8 AS NUMBER), '0000FFFFFFFFFFFF'xb) AS BIGINT ));
Result:
TO_BYTE(BITAND(6501293679989959966,'0000FFFFFFFFFFFF'XB)) --------------------------------------------------------- 00003C28184B2D1E