当前位置:Gxlcms > 数据库问题 > oracle中utl_raw

oracle中utl_raw

时间: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   插入   

人气教程排行