V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX  ›  huifeng  ›  全部回复第 1 页 / 共 1 页
回复总数  2
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.
2021-09-16 14:00:25 +08:00
回复了 huifeng 创建的主题 问与答 不懂就问,请教 oracle 的位操作
看了下方法说明 然后更不明白了
select UTL_RAW.BIT_AND(HEXTORAW('ead11'),HEXTORAW('00001')) from dual; 显示是 000001
关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   2722 人在线   最高记录 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 9ms · UTC 06:44 · PVG 14:44 · LAX 22:44 · JFK 01:44
Developed with CodeLauncher
♥ Do have faith in what you're doing.