select BIN_TO_NUM(1,0,1) a,bin_to_num(1,0) b from dual
bin_to_num函数,从9.1以后版本就有这个函数
select sum(data1)
from (select substr('101', rownum, 1) * power(2, length('101') - rownum) data1
from dual
connect by rownum <= length('101'))