BIN_TO_NUM

Oracle

Example

SELECT BIN_TO_NUM(0, 1, 1) FROM dual;

Output

6

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.