用UTL_RAW包,举例如下:
SQL> select to_number(utl_raw.bit_and(to_char(256,'fm000x'),to_char(128,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_AND(TO_CHAR(256,'FM000X'),TO_CHAR(128,'FM000X')),'XXXX')
------------------------------------------------------------------------------
0SQL> select to_number(utl_raw.bit_and(to_char(256,'fm000x'),to_char(256,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_AND(TO_CHAR(256,'FM000X'),TO_CHAR(256,'FM000X')),'XXXX')
------------------------------------------------------------------------------
256SQL> select to_number(utl_raw.bit_or(to_char(256,'fm000x'),to_char(128,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_OR(TO_CHAR(256,'FM000X'),TO_CHAR(128,'FM000X')),'XXXX')
-----------------------------------------------------------------------------
384SQL> select to_number(utl_raw.bit_or(to_char(256,'fm000x'),to_char(256,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_OR(TO_CHAR(256,'FM000X'),TO_CHAR(256,'FM000X')),'XXXX')
-----------------------------------------------------------------------------
256
SQL> select to_number(utl_raw.bit_and(to_char(256,'fm000x'),to_char(128,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_AND(TO_CHAR(256,'FM000X'),TO_CHAR(128,'FM000X')),'XXXX')
------------------------------------------------------------------------------
0SQL> select to_number(utl_raw.bit_and(to_char(256,'fm000x'),to_char(256,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_AND(TO_CHAR(256,'FM000X'),TO_CHAR(256,'FM000X')),'XXXX')
------------------------------------------------------------------------------
256SQL> select to_number(utl_raw.bit_or(to_char(256,'fm000x'),to_char(128,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_OR(TO_CHAR(256,'FM000X'),TO_CHAR(128,'FM000X')),'XXXX')
-----------------------------------------------------------------------------
384SQL> select to_number(utl_raw.bit_or(to_char(256,'fm000x'),to_char(256,'fm000x')),'xxxx')
2 from dual;TO_NUMBER(UTL_RAW.BIT_OR(TO_CHAR(256,'FM000X'),TO_CHAR(256,'FM000X')),'XXXX')
-----------------------------------------------------------------------------
256
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货