Re: HOW TO: Changing bits in numeric fields

From: Tom Zamani <tom_at_taten.com.au>
Date: Wed, 13 Oct 1999 10:09:03 +1000
Message-ID: <7u0ikd$h80$1@perki.connect.com.au>

Ralf,
May be you can use the combination of substr, instr, replace functions. Tom

ralf_foeller_at_my-deja.com wrote in message <7tv00b$ejp$1_at_nnrp1.deja.com>...
>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 - 19:09:03 CDT