huifeng 最近的时间轴更新 huifeng 最近的时间轴更新 |
huifengV2EX 第 454168 号会员，加入于 2019-11-19 21:27:35 +08:00 |
| 不懂就问，请教 oracle 的位操作 问与答 • huifeng • 2021-09-16 14:02:04 PM • 最后回复来自 huifeng | 2 |
| oracle 用什么类型来存储 bitmap 比较合适？ 问与答 • huifeng • 2021-09-15 18:07:21 PM |
| 标签信息怎么存储合适 问与答 • huifeng • 2021-09-15 12:58:23 PM • 最后回复来自 TheCure | 5 |
| 不懂就问，单服务器多端口做 redis cluster 有意义吗 问与答 • huifeng • 2021-07-02 22:18:23 PM • 最后回复来自 9yu | 6 |
huifeng 最近回复了
2021-09-16 14:02:04 +08:00 回复了 huifeng 创建的主题 › 问与答 › 不懂就问，请教 oracle 的位操作 |
方法说明：
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.
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.
2021-09-16 14:00:25 +08:00 回复了 huifeng 创建的主题 › 问与答 › 不懂就问，请教 oracle 的位操作 |
看了下方法说明 然后更不明白了
select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('00001')) from dual; 显示是 000001
select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('00001')) from dual; 显示是 000001
Select Language