select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('1')) from dual; 这个结果为什么么是 00AD11 ? 按我的理解不应该是 00001 吗
1
huifeng OP 看了下方法说明 然后更不明白了
select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('00001')) from dual; 显示是 000001 |
2
huifeng OP 方法说明:
B.2.2 UTL_RAW.BIT_AND UTL_RAW.BIT_AND performs a bitwise logical AND operation on two raw values. If the values have different lengths, then the AND operation is terminated after the last byte of the shorter of the two values. The unprocessed portion of the longer value is appended to the partial result to produce the final result. The length of the resulting value equals the longer of the two input values. |