Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: bitmask operations and SQL

Re: bitmask operations and SQL

From: <jtesta_at_my-dejanews.com>
Date: Wed, 20 May 1998 16:01:43 GMT
Message-ID: <6juup4$np1$1@nnrp1.dejanews.com>


I know some people have written some things, but as for standard part of oracle the closest you will find will be in ORACLE_HOME/rdbms/admin/utlraw is had bit-wise operations for raws, so i dont know how much that will help you.

joe
http://www.oracle-dba.com

In article <3562D2C5.9F83836A_at_bms.com>,   "Christopher J. Nalbone" <nalbonec_at_bms.com> wrote:
>
> This is a multi-part message in MIME format.
> --------------83CA6C1014C63F6A35F3EEA6
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Are there any SQL operators that support bitmask operations? I'd like
> to know if a certain bit within a number (integer) is set. For example,
>
> number in question number I'm interested in
> (decimal) (binary) (decimal) (binary)
> 27 11011 4 00100
>
> In a bitwise AND operation, this would return FALSE, since the single
> bit that corresponds to the number I'm interested in, 4, is not set.
>
> Thanks,
> Chris Nalbone
> Bristol-Myers Squibb
> nalbonec_at_bms.com
>
> --------------83CA6C1014C63F6A35F3EEA6
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Nalbone, Christopher J.
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Christopher J. Nalbone
> n: Nalbone;Christopher J.
> org: Bristol-Myers Squibb Co.
> adr: Rte 206 & Provinceline Rd;;P.O. Box
4000;Princeton;NJ;08543-4000;USA
> email;internet: nalbonec_at_bms.com
> title: Software Systems Advisor
> tel;work: (609) 252-4072
> tel;fax: (609) 252-6607
> x-mozilla-cpt: ;0
> x-mozilla-html: TRUE
> version: 2.1
> end: vcard
>
> --------------83CA6C1014C63F6A35F3EEA6--
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 20 1998 - 11:01:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US