Binary operator in Oracle?

[Francois Massey]

Hello everyone, I'm both new to this forum and to Oracle and I have the following question:
Is there any bitwise operator in Pl/Sql? I need to be able to test for bits and set/reset bits in integer values. Anyone has any idea how that can be achieved? Thanks!

[Bala Mohan]

I was recently reading SQL reference (9i). I came across a an operator (or a function, I dont recall) that will manipulate bits in an integer. You need to refer to SQL reference. I cannot give you the exact syntax now but I am sure you can do it in SQL (so you can use it in PLSQL). You download SQL reference pdf from otn website.
Hope this helps.
Bala.

[Francois Massey]

I've found it too. It's called BitAnd and it does the trick . Thanks Bala.