Re: Binary operations

Hi
See

Oracle7
http://www.oracledba.co.uk/tips/bitwise_ops.htm http://www.oramag.ru/default.htm?rub=3&ID=343 (RUSSIAN)

SQL>
  1* select (5 + 6 - bitand(5,6)) "5 OR 6" from dual SQL> /    5 OR 6

        7

Oracle8
UTL_RAW package
Syntax
UTL_RAW.BIT_XOR (
   r1 IN RAW,
   r2 IN RAW)
  RETURN RAW;
http://technet.oracle.com/files/search/search.htm?utl_raw http://technet.oracle.com/doc/server.815/a68001/utl_raw.htm

--
Stax

"Sergey V. Udaltsov" <sergey.oudaltsov_at_clients.ie> wrote in message news:<20010430.113600.1414829150.9887_at_clients.ie>...


> Hi all 

> 

> It there any way to perform binary operations (and, or) on NUMBER in

> Oracle? I could not find any info.

> For example

> a := 6 | 5 ( the result is definitely 7 :)


> Any ideas how to do this?