BITAND function???

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Thu, 3 Aug 2000 01:37:51 +0300
Message-Id: <10578.113760@fatcity.com>

Hi,

Any idea, what BITAND function does?

Following is a query which is used to list the names of all reverse key indexes:

SVRMGR> SELECT o.object_name

2> FROM dba_objects o
3> WHERE owner='SCOTT'
4> AND o.object_id IN (SELECT i.obj#
5> FROM ind$ i
6> WHERE BITAND(i.property,4) = 4);

OBJECT_NAME

---

ORD_ORD_NO_IDX
1 row selected.

TIA, Sandeep.
Riyadh, Saudi Arabia. Received on Wed Aug 02 2000 - 17:37:51 CDT