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

bin_to_num(1,0)

   <source lang="sql">

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

---

             2

SQL>

      </source>
   
  

bin_to_num(1,1)

   <source lang="sql">

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

---

             3

SQL>

      </source>
   
  

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

   <source lang="sql">

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>

      </source>
   
  

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

   <source lang="sql">

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>

      </source>