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

Home -> Community -> Usenet -> c.d.o.server -> Re: Bitwise logic in stored procedure?

Re: Bitwise logic in stored procedure?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 08 Jul 1999 21:14:55 +0800
Message-ID: <3784A44F.743A@yahoo.com>


Darren Lee wrote:
>
> Is it possible to do bitwise logic in an Oracle stored procedure? I want to
> do a bitwise AND with a variable that I pass in to the stored procedure to
> determine which field I want to update in the database. Is this possible?
>
> Thanks,
> Darren

There is an undocumented function (or is it a proc) called "bitand" in (I think) $ORACLE_HOME/rdbms/admin/utlraw.sql (or something similar)

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 Thu Jul 08 1999 - 08:14:55 CDT

Original text of this message

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