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: Bit Shifting Operations

Re: Bit Shifting Operations

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 18 Dec 1999 19:40:14 +0800
Message-ID: <385B729E.77C@yahoo.com>


Wm. G. Urquhart wrote:
>
> Can anyone tell me if it's possible to bit shift columns in a select
> statement?
>
> I can't find anything in the books!
>
> Thanks in advance.
>
> William.

Oracle has the BITAND operation (see UTLRAW.SQL) from which you can build OR, XOR and thus most of the other bit wise operations...Not a great solution but workable..

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Dec 18 1999 - 05:40:14 CST

Original text of this message

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