HOW TO: Changing bits in numeric fields

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:47:57 CDT