Re: Bitwise masking...

From: <nickvysh_at_my-deja.com>
Date: Fri, 29 Dec 2000 00:59:02 GMT
Message-ID: <92gnkk$9o1$1@nnrp1.deja.com>

Don't know about OR, XOR but you can do AND. Try:

select decode(bitand(6,3),2,'it works!','doesnt work') from dual

In article <q0Q26.20$Gf6.1572_at_news3.voicenet.com>, "JAP" <JAP_at_unknown.com> wrote:
> I have a (10,0) Number format field that I would like to run logical
bitwise
> operations using masks. For example AND, OR and Exclusive OR
operations...
>
> 0011111111
> 0000001000 AND
> =============
> return TRUE
>
> Is this possible using:
>
> * PL/SQL
> * native or developed functions
> * Stored procedures
>
> Thanks for any help,
> Schmen
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 28 2000 - 18:59:02 CST