Skip to content
v1.36.1
Install

BIN_TO_NUM

BIN_TO_NUM(bit1, bit2, …)

Section titled “BIN_TO_NUM(bit1, bit2, …)”
  • bit1, bit2, …: Bit values (0 or 1), most significant bit first, that form the binary number.

Example

Section titled “Example”
SELECT BIN_TO_NUM(0, 1, 1) FROM dual;

Output

Section titled “Output”
6

Explanation

Section titled “Explanation”

The BIN_TO_NUM function takes binary numbers as arguments and returns its decimal equivalent. In the provided example, binary 011 is converted to decimal, resulting in 6.