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

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 - 07:59:55 CDT