Oracle bitwise exception in Oracle

Question

In SQL Server, I used the ^ character, however this does not work in Oracle .

How to make bitwise exclusive OR in Oracle?

Answer 1

From the docs:

 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 see what these works, follow the logic with 0s and 1s for input, and then no, that there are no borrowings or caries.

- MarkusQ

Answer 2

There is a BITAND statement:

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

You can create other operators from it ; and here .

Answer 3

There is no easy way.

You can specify HEX string values ​​in RAW values ​​and use UTL_RAW :

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

Answer 4

Here is an article about creating the BIT_OR method. (thanks to Kvasny)