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

Home -> Community -> Usenet -> c.d.o.server -> Re: binary logic in SQL?

Re: binary logic in SQL?

From: teddy <softplan_at_bdg.centrin.net.id>
Date: Fri, 8 Jan 1999 06:11:57 +0700
Message-ID: <36953f81.0@news.centrin.net.id>


this code works :

select * from emp where bitand(flags ,2) = 2;

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.
>
>Thanks,
>-Rodney Volz
>
Received on Thu Jan 07 1999 - 17:11:57 CST

Original text of this message

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