Get a number nth bit value in oracle
The shortest expression you can get is:

least(bitand(a, power(2, n-1)), 1)


where you want to find the nth bit of a.

The shortest query with this expression is:

select least(bitand(a, power(2, n-1)), 1) from dual;


From what I've read the above expression also works in PL/SQL, eg:

l_bit_n := least(bitand(a, power(2, n-1)), 1);