Re: HOW TO: Changing bits in numeric fields

From: <ralf_foeller_at_my-deja.com>
Date: Tue, 12 Oct 1999 13:59:35 GMT
Message-ID: <7tvert$ovi$1@nnrp1.deja.com>

Hi Matthias,

thank you very much, but this is not the solution for our problem, because we run on both OS Novell and Windows NT.

Any other ideas?

Thanks
Ralf

> Hi Ralf,
>
> I have this problem too.
> If you use Windows NT as your Oracle Server OSyou can get my
> orabin.dll.
>
> Ciao
> Matthias
>
> On Tue, 12 Oct 1999 09:47:57 GMT, ralf_foeller_at_my-deja.com wrote:
>
> >Hi,
> >
> >i want to set a specific bit in a numeric field. It seems, that
oracle
> >does
> >not allow boolean operations like AND or OR with numeric variables.
> >E.g. to set bit 3, i want to use something like that
> >
> >UPDATE Table1
> >SET Field1 = Field1 OR 8; (I know, it's not
possible)
> >
> >Any ideas?
> >
> >Thanks
> >Ralf
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 12 1999 - 08:59:35 CDT