How to do bitwise operations in Oracle 1

[amortillaro]

Hi guys:
I didn't found any bitwise operators in oracle, so I suppouse I should build a function for this (let me know if I'm wrong).
Then how can I convert a number to it's binary representation in oracle?

byte=1: 0000 0001
byte=4: 0000 0100
result: 0000 0101

Thank's.. Aishel

 

[amortillaro]

another example...

5 - 0101
3 - 0011
---------- and operation
1 - 0001

.

 

[ddrillich]

Please try:
select bitand(5,3) from dual;

Regards,
Dan

 

[amortillaro]

here is an extension to Or and Xor

function bitor(p_dec1 number, p_dec2 number) return number is
begin
return p_dec1-bitand(p_dec1,p_dec2)+p_dec2;
end;

function bitxor(p_dec1 number, p_dec2 number) return number is
begin
return bitor(p_dec1,p_dec2)-bitand(p_dec1,p_dec2);
-- or you could use: return p_dec1-2*bitand(p_dec1,p_dec2)+p_dec2;
end;
Further information about bitwise operation in oracle can be found in

http://www.jlcomp.demon.co.uk/faq/bitwise.html

.

Thanks for your help, greetings. Aishel

 

[sem]

Look at UTL_RAW package, it supports both but only for RAWs

Regards, Dima

http://seminihin.narod.ru

 

[SirCharles]

Here's one I like:
This is written in MySQL and to translate to oracle, the first part of the select would probably go
something like this:

select name
from survey
where bitand(status, 8) !=0
and bitand(status, 7) = 0

define('STATUS_ACTIVE', 0x01);
define('STATUS_DONE', 0x02);
define('STATUS_DELETED', 0x04);
define('STATUS_TEST', 0x08);

$statusbad = (STATUS_DONE | STATUS_DELETED | STATUS_ACTIVE);
$statusok = STATUS_TEST;
if($HTTP_SESSION_VARS['acl']['superuser'] == 'Y') {
$sql = "SELECT id,name,title,owner,realm FROM survey
WHERE (status & $statusok)
AND NOT (status & $statusbad)
ORDER BY id DESC";