doing logical (bitwise) comparions.. AND, OR, etc

# Thread: doing logical (bitwise) comparions.. AND, OR, etc

1. Join Date
Jul 2000
Posts
105
I have several SQL processes that each have their own value...1,2,4,8,16, etc... if the steps 1,2,4 must execute before step 8 I can have each step look at the values already ran.. i.e. 1,2,3,4,5,6,7.
If the total is 5 for instance, I know I ran steps 1 and 4, but not 2.

The problem is I am trying to do this via code... is there a way to do a bitmap AND of two numbers?

i.e. If I do a bitmap NOT AND of 2 and 5, I will get zero, for those of you who know how to do this. C/C+ has simple functions... is there one in PL/SQL?

i.e. 2 = 0000 0010
5 = 0000 0101
NAND= 0000 0000 = 0

2. Join Date
Jul 2000
Posts
105

## got it

simpy use utl_raw...

to do a NOT AND (XAND) of 4 and 7)..
the result if true, is the original number (4), a false return is zero

select utl_raw.bit_and (hextoraw(4), utl_raw.bit_xor(hextoraw(4), hextoraw(7))) from dual

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•