SELECT BIN_TO_NUM(1) AS "bin_to_num"
FROM dual;


SELECT BIN_TO_NUM(1, 0) AS "bin_to_num"
FROM dual;


SELECT
BIN_TO_NUM(1, 1) AS two_values,
BIN_TO_NUM(1, 0, 1) AS three_values,
BIN_TO_NUM(1, 1, 0, 1) AS four_values,
BIN_TO_NUM(1, 0, 0, 1, 1, 1, 0, 1) AS eight_values
FROM dual;

http://www.databasestar.com/oracle-bin_to_num

A few examples of the BIN_TO_NUM function.

Oracle BIN_TO_NUM Function

sql, Oracle

SQL