Re: Bit-Manipulation???

A copy of this was sent to P Jeromel <pjeromel_at_hotmail.com> (if that email address didn't require changing) On Mon, 21 Jun 1999 09:42:46 +0930, you wrote:

>Thomas,
>
>Thanks for the function, although, which package does the bitand() come from?
>(Or what permissions do I need, I can't seem to execute it).
>

what is the error? bitand() is available everywhere -- its used in the data dictionary, in plsql, all over. Its an internal function like substr. can you send me a cut and paste of your attempt to use it and the resulting error?

>Thanks.
>Paul
>
>Thomas Kyte wrote:
>
>> A copy of this was sent to P Jeromel <pjeromel_at_hotmail.com>
>> (if that email address didn't require changing)
>> On Sun, 20 Jun 1999 18:38:30 +0930, you wrote:
>>
>> >Hi All,
>> >
>> >Does anyone know if there are any packages available which allows bit
>> >manipulation
>> >on datatypes (preferably NUMBER or REAL)???
>> >
>>
>> what kind of bit manipulations?
>>
>> there is an undocumented 'bitand()' routine you can call.
>>
>> If you need bitor, this might do it for you:
>>
>> CREATE OR replace FUNCTION bitor( x IN NUMBER, y IN NUMBER ) RETURN NUMBER
>> AS
>> l_x PLS_INTEGER DEFAULT x;
>> l_y PLS_INTEGER DEFAULT y;
>> l_r PLS_INTEGER DEFAULT 0;
>> l_tmp PLS_INTEGER := 1;
>> BEGIN
>> FOR i IN 1 .. 32 LOOP
>> IF ( bitand(l_x,l_tmp) = l_tmp OR bitand(l_y,l_tmp) = l_tmp )
>> THEN
>> l_r := l_r + l_tmp;
>> END IF;
>> l_tmp := l_tmp * 2;
>> exit when ( l_tmp >= l_x AND l_tmp >= l_y );
>> END LOOP;
>>
>> RETURN l_r;
>> END;
>> /
>>
>> that function is callable from sql as well. both bitand and the above bitor
>> only work with 32bit integers (don't work with abs(numbers) > 2^31)
>>
>> >I know of the UTL_RAW with it's functions/procedures.
>> >
>>
>> >(It's for a small Data Conversion job - so I would rather not write
>> >something too large to do the job).
>> >
>> >Is there anything else out there which comes with 8.0.5 Workgroup
>> >Server?
>> >
>> >Thanks.
>> >Paul
>> >
>>
>> --
>> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
>> Current article is "Fine Grained Access Control", added June 8'th
>>
>> Thomas Kyte tkyte_at_us.oracle.com
>> Oracle Service Industries Reston, VA USA
>>
>> Opinions are mine and do not necessarily reflect those of Oracle Corporation

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Jun 20 1999 - 19:51:31 CDT