Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: bitwise AND / OR in query?

Re: bitwise AND / OR in query?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 12 Nov 1999 16:57:07 +0800
Message-ID: <382BD662.7C9B@yahoo.com>


tim_lossen_at_my-deja.com wrote:
>
> is there any way to do bitwise operations
> in the WHERE-clause of a query?
>
> ... something like:
>
> SELECT * FROM .... WHERE ((field AND mask) > 0)
>
> --- tim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Check the "BITAND" function - it does what you are after..

--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Nov 12 1999 - 02:57:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US