Re: binary logic in SQL?

From: Rodney Volz <rodney_at_watchtower.LF.net>
Date: 9 Jan 1999 12:47:41 GMT
Message-ID: <777j5d$kug$1@news.LF.net>

In article <36953f81.0_at_news.centrin.net.id>, teddy <softplan_at_bdg.centrin.net.id> wrote:
>Rodney Volz wrote in message <76vsb0$j1i$1_at_news.LF.net>...
>>Is there any way to use bitmap masks in oracle? What
>>I need is something like:
>>
>> select * from emp where flags & 0x02 != 0;
>>
>>where "flags & 0x02" behaves as if it was C code.
>
>this code works :
>
>select * from emp where bitand(flags ,2) = 2;
>
>--- teddy.

Hmm, sqlplus doesn't seem to know about that function. I'm using Oracle 7.3.3, is that a new function of oracle8?

The function seems to be exactly what I am looking for.

Regards,
-Rodney Volz Received on Sat Jan 09 1999 - 06:47:41 CST