C#

stilz wrote:

will the future versions of Oracle database continue to work with Microsoft's driver?

stilz wrote:

Lastly, I'm still curious as to why getSchema("Tables") works with Oracle's driver but not getSchema

Luc Pattyn wrote:

BTW: why ask for an algorithm in a language oriented forum that does not match your language?
we do have a "Math and algorithms" forum.

Ravadre wrote:

Is not the forum called "Algorithms",

byte someByte ...;
byte masked = (someByte & 0xE) >> 2;

OverlayType value = (OverlayType)(type & 0x7); <br />
OverlayType flags = (OverlayType)(type & 0xC0);<br />

[Flags]
public enum OverlayTypes 
{    Public       = 0,
     OwnedByOther = 1,
     OwnedByGroup = 2,
     OwnedBySelf  = 4,
     ForSale      = 8,
     Auction      = 16,
     BorderWest   = 32,
     BorderSouth  = 64
}

OverlayTypes types = OverlayTypes.OwnedBySelf | OverlayTypes.ForSale | OverlayTypes.BorderWest;
if ((types & OverlayTypes.OwnedBySelf) == OverlayTypes.OwnedBySelf)
{
    MessageBox.Show("Owned by self");
}

OverlayTypes types = OverlayTypes.OwnedBySelf | OverlayTypes.ForSale | OverlayTypes.BorderWest;
OverlayTypes theseTypes = OverlayTypes.OwnedBySelf | OverlayTypes.BorderWest;
if ((types & theseTypes) == theseTypes)
{
    MessageBox.Show("Owned by self, and borders west");
}

Given the example number 179
10110011  number in binary
--+++---
00111000  mask to extract bits 3-5

00110000  intermediate result
00000110  final result

76543210  bit indices

The mask will extract the 3 bits marked with the +'s.

These are the 4 logical steps in the process

1) create a bit mask to cover the region of interest, 
   in this case 3 bits,  binary 111 or hex 0x07
   Byte mask = 0x07;
   
2) shift the mask into the correct position 
   In the example the mask starts at bit 3
   Byte mask = 0x07 << 3;  // mask is now binary 111000
   
3) Apply the mask to the number with the bitwise AND operation.
   This allows the bits from the number to fall through 
   the mask into the intermediate result.
   
   Int32 intermediateResult = number & mask;
 or
   Int32 intermediateResult = number & (0x07 << 3);
   // the value is 110000
   
   Note that when we do this the result is automatically widened to 32 bits.
   
4) Shift the intermediate result to the right to get the actual value
   of the bits of interest.
   
   Int32 result = intermediateResult >> 3;
 or
   Int32 result = (number & (0x07 << 3)) >> 3;
   // result is binary 110 or 0x06 or decimal 6
   
   As result was widened to 32 bits we can cast back to a byte if desired.
   Take note of all the parentheses.
   
   Byte result = (Byte)((number & (0x07 << 3)) >> 3);
   
   If you want to see the result as a binary formatted string
   
   String s = Convert.ToString(result, 2).PadLeft(8, '0');
   // s is "00000110"