Re: Bitwise & operator - Oracle 8i - Std server - How do you do it ?

There exists a "bitand" function in the standard package.

  function BITAND (LEFT binary_integer, RIGHT binary_integer)

        return binary_integer;

try
select to_char(bitand(16, 2) ) from dual;

"CME" <support_at_cmesys.demon.co.uk> schrieb im Newsbeitrag news:995374849.15009.0.nnrp-13.c2de4217_at_news.demon.co.uk...
> Dear all,
>
> I am trying to write a bitwise and operator to check a flag we store in an
> Number (using Oracle Std Server 8i).
>
> I have looked through the help and the only support I can find is for RAW
> datatypes:
>
> UTL_RAW.BIT_AND(x,y)
>
> Also there is a section on Bit Operators (converting from SQL / Sybase)
 and
> it states writing a package, which is a great idea....
>
> However how do you write a function / procedure to do a bitwise & ?
>
> Any help would be gratefully accepted.
>
> Thanks
>
>
> Matt.
>
>
>
>
Received on Tue Jul 17 2001 - 11:47:06 CDT