BIN_TO_NUM

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 ]... )

Arguments

expression

An expression that evaluates to either 0 (zero) or 1 (one) which is the value of a bit in the bit vector.

Examples

Example 7-33 Converting Bit Vectors to a Number

SHOW BIN_TO_NUM(1,0,1,0)
10.00