位运算

and T F T T F F F F 取位运算， x and 000100取得1的那一位 Oracle : bitand函数 select utl_raw.bit_and(hextoraw('300'), hextoraw('0f0')) example2 from dual; or T F T T T F T F 无条件赋值， x or 1则无条件将末位设为1 Oracle : CREATE OR REPLACE FUNCTION bitor (n1 NUMBER, n2 NUMBER) RETURN NUMBER IS n1_tmp NUMBER := trunc(n1); n2_tmp NUMBER := trunc(n2); BEGIN RETURN n1_tmp + n2_tmp - bitand(n1_tmp, n2_tmp); END; / select utl_raw.bit_or(hextoraw('300'), hextoraw('0f0')) example2 from dual; xor T F T F T F T F 特定位取反， x xor 1111取反， x xor 0000不变 Oracle : CREATE OR REPLACE FUNCTION bitxor (n1 NUMBER, n2 NUMBER) RETURN NUMBER IS n1_tmp NUMBER := trunc(n1); n2_tmp NUMBER := trunc(n2); BEGIN RETURN n1_tmp + n2_tmp - bitand(n1_tmp, n2_tmp)*2; END; / select utl_raw.bit_xor(hextoraw('300'), hextoraw('0f0')) example2 from dual;