The BIN_TO_NUM function converts a bit vector to its equivalent number.
BIN_TO_NUM is useful in data warehousing applications for selecting groups of interest using grouping sets.
NUMBER
BIN_TO_NUM(expression [, expression ]... )
An expression that evaluates to either 0
(zero) or 1
(one) which is the value of a bit in the bit vector.