BIN_TO_NUM

BIN_TO_NUM converts a bit vector to its equivalent number.

Return Value

NUMBER

Syntax

BIN_TO_NUM(expr [, expr ]... ) 

Arguments

expr is a numeric expression with a value of 0 or 1 for the value of a bit in the bit vector.

Example

BIN_TO_NUM(1,0,1,0) returns the value 10.00.

Copyright © 2003, 2007, Oracle. All rights reserved.