Posted By

bbrumm on 03/27/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/27/17 11:14am

Statistics

Viewed 1250 times

Favorited by 0 user(s)

Related snippets

Oracle BIN_TO_NUM Function

/ Published in: SQL

A few examples of the BIN_TO_NUM function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;