Go to main content
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.
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.
Example 7-33 Converting Bit Vectors to a Number