时间:2021-07-01 10:21:17 帮助过:4人阅读
4、位操作函数
FUNCTION bit_and(r1 IN RAW,
r2 IN RAW) RETURN RAW;
FUNCTION bit_or(r1 IN RAW,
r2 IN RAW) RETURN RAW;
FUNCTION bit_xor(r1 IN RAW,
r2 IN RAW) RETURN RAW;
如:
select utl_raw.bit_and(‘12344321‘,‘0f‘) from dual;
select utl_raw.bit_or(‘12344321‘,‘0f‘) from dual;
select utl_raw.bit_xor(‘12344321‘,‘0f‘) from dual;
结果分别为:
02344321、1F344321、1D344321
oracle中utl_raw
标签:function tab rom into arc number varchar2 UNC 插入