17,382
社区成员
发帖
与我相关
我的任务
分享oracle的与运算符号是什么？
oracle的与运算符号是什么？
例如在sqlserver中
select 256 & 128 结果是0
select 256 & 256 结果是256
还有或运算符呢？
例如在sqlserver中
select 256 & 128 结果是0
select 256 & 256 结果是256
还有或运算符呢？
...全文
请发表友善的回复…
发表回复
njhart2003 2006-01-07
- 打赏
- 举报
用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')
------------------------------------------------------------------------------
0
SQL> 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')
------------------------------------------------------------------------------
256
SQL> 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')
-----------------------------------------------------------------------------
384
SQL> 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')
------------------------------------------------------------------------------
0
SQL> 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')
------------------------------------------------------------------------------
256
SQL> 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')
-----------------------------------------------------------------------------
384
SQL> 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
