HOW TO: Changing bits in numeric fields

From: <ralf_foeller_at_my-deja.com>
Date: Tue, 12 Oct 1999 09:45:48 GMT
Message-ID: <7tv00b$ejp$1@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 - 04:45:48 CDT