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??

Thanks

There's the BITAND operator:

select bitand(49,54)+0 from dual;

You are able to build up the other operators from this and here.

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.

-- MarkusQ

There is no smart way.

You might cast string HEX values into RAW values and employ UTL_RAW:

SELECT UTL_RAW.bit_xor(HEXTORAW(TO_CHAR(1, 'FMX')), HEXTORAW(TO_CHAR(2, 'FMX')))
FROM dual

---
 03