Oracle/PLSQL: Bin_To_Num Function

In Oracle/PLSQL, the bin_to_num function converts a bit vector to a number.

Syntax

The syntax for the bin_to_num function is:

bin_to_num( expr1, expr2, ... expr_n)

expr1, expr2, ... expr_n must be either 0 or 1 values. They represent bits in a bit vector.

Applies To

• Oracle 11g, Oracle 10g, Oracle 9i

For Example

bin_to_num(1)	would return 1
bin_to_num(1,0)	would return 2
bin_to_num(1,1)	would return 3
bin_to_num(1,1,1,0)	would return 14
bin_to_num(1,1,1,1)	would return 15