select * from insurance_claims where category = 'XYZ';
select * from insurnace_claims where total_paid > 100000;
select * from insurance_claims where loss_date between to_date('2015','rrrr') and to_date('2015','rrrr')-1;

select
            case when a.category = 'XYZ' then power(2,0) else 0 end
          + case when a.total_paid > 1000 then power(2,1) else 0 end
          + case when a.loss_date between to_date('2015','rrrr') and to_date('2015','rrrr')-1 the power(2,2) else 0 end
       query_key
     ,a.*
from insurance_claims a
where (
             a.category = 'XYZ'
         or  a.total_paid > 100000
         or  a.loss_date between to_date('2015','rrrr') and to_date('2015','rrrr')-1
      )
/

select bitand(1,power(2,1)) from dual;
select bitand(2,power(2,1)) from dual;
select bitand(3,power(2,1)) from dual;
select bitand(4,power(2,1)) from dual;

01:48:47 SQL> select bitand(1,power(2,1)) from dual;

BITAND(1,POWER(2,1))
--------------------
                   0

1 row selected.

Elapsed: 00:00:00.01
01:51:23 SQL> select bitand(2,power(2,1)) from dual;

BITAND(2,POWER(2,1))
--------------------
                   2

1 row selected.

Elapsed: 00:00:00.00
01:51:23 SQL> select bitand(3,power(2,1)) from dual;

BITAND(3,POWER(2,1))
--------------------
                   2

1 row selected.

Elapsed: 00:00:00.02
01:51:23 SQL> select bitand(4,power(2,1)) from dual;

BITAND(4,POWER(2,1))
--------------------
                   0

1 row selected.

Elapsed: 00:00:00.02