Download SQL Users` Manual - ALTIBASE Customer Support

Transcript
Numeric Functions
Description
Return the XOR result of between bit_a and bit_a.
Examples
iSQL> SELECT TO_CHAR( BITXOR( BIT'01010101', BIT'10101010' ) ) FROM DUAL;
TO_CHAR( BITXOR( BIT'01010101', BIT'1010
-------------------------------------------11111111
1 row selected.
BITNOT
Syntax
BITNOT (bit_a)
Description
Return the NOT result of bit_a.
Examples
iSQL> SELECT TO_CHAR( BITNOT( BIT'01010101' ) ) FROM DUAL;
TO_CHAR( BITNOT( BIT'01010101' ) )
-------------------------------------10101010
1 row selected.
336
SQL Functions