Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: binary logic in SQL?
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
![]() |
![]() |