select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('1')) from dual; 这个结果为什么么是 00AD11 ？ 按我的理解不应该是 00001 吗
This topic created in 1886 days ago, the information mentioned may be changed or developed.
 |
1
看了下方法说明 然后更不明白了
select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('00001')) from dual; 显示是 000001 |
|
2
方法说明：
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. |
Select Language