Re: Bitwise AND and OR in a PL/SQL function

Jake Anderson wrote:
>
> Is there a function or operator for a bitwise AND and OR function in PL/SQL.
> I need to OR together some numbers and then put them into a single field.
> i.e. 2 OR 4 = 6; 2 OR 2 = 2. I also need an AND function to check which
> bits are already on. Does oracle have these bitwise functions?
>
> A shift left and shift right operator would be nice too but not as critical.
>
> Thanks
>
> --
> Jake Anderson
> jakeanderson_at_byu.edu
> MTC Development

Check my web site for examples of AND, OR, XOR.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy