Re: BITAND function???

From: Tom Pall <tpall_at_cdproc.com>
Date: Thu, 3 Aug 2000 15:06:43 -0500
Message-Id: <10578.113786@fatcity.com>

Precisely what it says. It is doing a bit by bit and of i.property with 4 [ binary 100).

Bit and

does a logical AND with the bits in the first operand with the bits in the second operand).

1 AND 1 = 1
1 AND 0 = 0
0 AND 0 = 0

----- Original Message -----
From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 03, 2000 1:16 PM
Subject: BITAND function???

> 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.
> --
> Author: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Aug 03 2000 - 15:06:43 CDT