利用utl_raw
查询表t1中由那几个数组成
select *
from t1
where utl_raw.cast_to_binary_integer(utl_raw.bit_and(utl_raw.cast_from_binary_integer(id),
utl_raw.cast_from_binary_integer(7))) <> 0
利用utl_raw
查询表t1中由那几个数组成
select *
from t1
where utl_raw.cast_to_binary_integer(utl_raw.bit_and(utl_raw.cast_from_binary_integer(id),
utl_raw.cast_from_binary_integer(7))) <> 0