jack-zheng
2/28/2018 - 7:31 AM

sql, syntax

sql, syntax

BITAND: 位与运算

sample

SELECT 
  BITANT(3, 1) 'cal ret'
FROM dual;

---------------------
outout: 
CAL_RET
-------
1

above logic equals to:
11 =   "3" 
01 =   "1"
====    bitand
01 =    "1" 
  • Oracle has no BITOR operation, but Hana has.
  • when select from Hana, table name should be dummy.