SQL関連

BINAND_DECODE.sql

select DATA_FLGS,decode(bitand(DATA_FLGS,16),16,'○','×') from DATA where ID='1' ;

DATA_FLGS       DE
--------------- --
          16644 ×

select DATA_FLGS,decode(bitand(DATA_FLGS,16),16,'○','×') from DATA where ID='2' ;

DATA_FLGS       DE
--------------- --
          24605 ○

BITAND.sql

SQL> select DATA_FLGS,bitand(DATA_FLGS,16) from DATA where ID='1' ;

DATA_FLGS       BITAND(DATA_FLGS,16)
--------------- --------------------------
          16644                  0

SQL> select DATA_FLGS,bitand(DATA_FLGS,16) from DATA where ID='2' ;

DATA_FLGS       BITAND(DATA_FLGS,16)
--------------- --------------------------
          24605                 16

BITAND2.sql

select DATA_FLGS,bitand(DATA_FLGS,POWER(2, (5 - 1))) from DATA where ID='2' ;

DATA_FLGS       BITAND(DATA_FLGS,POWER(2, (5 - 1)))
--------------- --------------------------
          24605                 16

decimal.sql

SQL> select DATA_FLGS from DATA;

ID          DATA_FLGS
----------- ---------------
          1           16644
          2           24605