BIN_TO_NUM

     This will convert the binary value to its numerical equivalent.

     Syntax: bin_to_num( binary_bits)

     Ex:

          SQL> select bin_to_num(1,1,0) from dual;

BIN_TO_NUM(1,1,0)

------------------------

                6

Ø  If all the bits are zero then it produces zero.

Ø  If all the bits are null then it produces an error.