Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

BIN_TO_NUM(x)

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>