Bitwise functions
The following is a list of bitwise functions supported by xfODBC. Note that “exp” represents an expression that results in a numeric value. xfODBC converts non-integer numeric values into integers before performing a bitwise operation.
For links to more information on xfODBC's support for SQL, see Appendix B: SQL Support.
BITAND
BITAND(num_exp1, num_exp2)
This function returns the result of a bitwise AND operation performed on two numeric values.
For example, the following query returns 1 (0001 AND 1111 = 0001).
SELECT BITAND(1, 15) FROM dual
BITOR
BITOR(num_exp1, num_exp2)
This function returns the result of a bitwise OR operation performed on two numeric values.
For example, the following query returns 15 (0010 OR 1101 = 1111).
SELECT BITOR(2, 13) FROM dual
BITXOR
BITXOR(num_exp1, num_exp2)
This function returns the result of a bitwise exclusive OR operation performed on two numeric values.
For example, the following query returns 14 (0001 XOR 1111 = 1110).
SELECT BITXOR(1, 15) FROM dual