Oracle PL/SQL/Numeric Math Functions/BIN TO NUM

bin_to_num(1,0)

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

bin_to_num(1,1)

SQL> select bin_to_num(1,1) from dual;
BIN_TO_NUM(1,1)
---------------
              3
SQL>

bin_to_num(1,1,1,0), bin_to_num(1,1,1,1)

SQL>
SQL> select bin_to_num(1,1,1,0) from dual;
BIN_TO_NUM(1,1,1,0)
-------------------
                 14
SQL> select bin_to_num(1,1,1,1) from dual;
BIN_TO_NUM(1,1,1,1)
-------------------
                 15
SQL>

BIN_TO_NUM(x): Converts x to a binary number, Returns a NUMBER

SQL> --BIN_TO_NUM(x): Converts x to a binary number. Returns a NUMBER.
SQL>
SQL>
SQL> select bin_to_num(1) from dual;
BIN_TO_NUM(1)
-------------
            1
SQL>