Re: PL/SQL bitwise operators?

From: Peter Brenner <pbrenner_at_charlotte.infi.net>
Date: Tue, 30 Mar 1999 20:06:20 -0500
Message-ID: <7drsfb$q2o$1@nw003t.infi.net>

Yes. In the package utl_raw there is:

  FUNCTION bit_and(r1 IN RAW,

                   r2 IN RAW) RETURN RAW;

    pragma RESTRICT_REFERENCES(bit_and, WNDS, RNDS, WNPS, RNPS);

• Perform bitwise logical "and" of the values in raw r1 with raw r2
• and return the "anded" result raw.

 FUNCTION bit_or(r1 IN RAW,

                  r2 IN RAW) RETURN RAW;

    pragma RESTRICT_REFERENCES(bit_or, WNDS, RNDS, WNPS, RNPS);

• Perform bitwise logical "or" of the values in raw r1 with raw r2
• and return the "or'd" result raw

  FUNCTION bit_xor(r1 IN RAW,

                   r2 IN RAW) RETURN RAW;

    pragma RESTRICT_REFERENCES(bit_xor, WNDS, RNDS, WNPS, RNPS);

• Perform bitwise logical "exclusive or" of the values in raw r1
• with raw r2 and return the "xor'd" result raw.

  FUNCTION bit_complement(r IN RAW) RETURN RAW;     pragma RESTRICT_REFERENCES(bit_complement, WNDS, RNDS, WNPS, RNPS);

• Perform bitwise logical "complement" of the values in raw r
• and return the "complement'ed" result raw.

HTH
Peter

.

bit_and - Function which preforms a logical and bit_or - Function which preforms a loical or

Julie Anne Jarrard wrote in message <37013370.6F2AF2D8_at_aug.edu>...
>Is anyone aware of any bitwise operators (and, or) in PL/SQL? I have
>been unable to find anything in my reference manuals.
>
>
>Thanks,
>
>Julie Jarrard
>jjarrard_at_aug.edu
Received on Tue Mar 30 1999 - 19:06:20 CST