![]() Previous |
![]() Next |
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.
Return Values
NUMBER
Syntax
BIN_TO_NUM(expression [, expression ]... )
Parameters
An expression that evaluates to either 0
(zero) or 1
(one) which is the value of a bit in the bit vector.
Examples