Re: HOW TO: Changing bits in numeric fields

From: Matthias Barmeier <barmeier_at_mamba.com>
Date: Tue, 12 Oct 1999 12:42:33 +0200
Message-ID: <PBADOJ4SwWst4+s=QJT7wrZcamON@4ax.com>

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.
Received on Tue Oct 12 1999 - 05:42:33 CDT