Advanced Search

Return to Snippet

Revision: 71917
at March 27, 2017 11:14 by bbrumm
Initial Code 
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;
Initial URL 
http://www.databasestar.com/oracle-bin_to_num
Initial Description 
A few examples of the BIN_TO_NUM function.
Initial Title 
Oracle BIN_TO_NUM Function
Initial Tags 
sql, Oracle
Initial Language 
SQL