In SQL Server I've been while using ^ symbol however that does not appear to operate in Oracle. How do you perform a bitwise exclusive Or perhaps in Oracle??
In the paperwork:
function bitor(p1 number, p2 number) return number is begin return p1-bitand(p1,p2)+p2; end; function bitxor(p1 number, p2 number) return number is begin return bitor(p1,p2)-bitand(p1,p2); end;
To determine these work, stick to the logic with only 0s and 1s for input, after which not too you will find no borrow or caries.
There is no smart way.
You might cast string
HEX values into
RAW values and employ
SELECT UTL_RAW.bit_xor(HEXTORAW(TO_CHAR(1, 'FMX')), HEXTORAW(TO_CHAR(2, 'FMX'))) FROM dual --- 03