| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> decimal to binary masks
Hi,
I want to test for a given bit being set.
for example a number field being used as flag storage.
0=no lock 1=invoiced_locked 2=shipping_locked 4=packing_locked
if bitset(flag,2)
then
.....
else
XXXXX
endif
I don't want to have to use UTL_RAW, since it seems to only work on varchar2 & rawtypes
any routines out there
steve Received on Tue Feb 08 2000 - 22:16:04 CST
 |
 |