Logical OR testing

From: <eteckard_at_yahoo.com>
Date: Tue, 01 Feb 2000 18:24:27 GMT
Message-ID: <8778cl$r69$1@nnrp1.deja.com>

Does anyone know the proper syntax (if you can even do it at all) for doing bitwise logical AND testing within the WHERE clause of a SQL statement on Oracle?

Here's Microsoft's documentation on how to do it in SQL Server...

http://msdn.microsoft.com/library/psdk/sql/operator_9.htm

...but I can't find any Oracle documentation on how to accomplish the same task on Oracle.

For example, here's a snip of a procedure I wrote for SQL Server...

---

if (@iStatusLong & 32) > 0

    begin
    /*

        do something...
    */
    end

---

Anybody?

Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 01 2000 - 12:24:27 CST