Friday, 1 April 2016

SQL Bitand

This will perform bitwise and operation.

     Syntax: bitand (value1, value2)        

     Ex:
          SQL> select bitand(2,3), bitand(0,0), bitand(1,1), bitand(null,null), bitand(-2,-3) from
                   dual;
BITAND(2,3) BITAND(0,0) BITAND(1,1) BITAND(NULL,NULL) BITAND(-2,-3)
--------------  ---------------  --------------   ------------------------  -----------------

          2           0                      1                                                          -4

No comments:

Post a Comment