|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
BIN_TO_NUM converts a bit vector to its equivalent number. Each argument to this function represents a bit in the bit vector. Each
expr must evaluate to 0 or 1. This function returns Oracle
BIN_TO_NUM is useful in data warehousing applications for selecting groups of interest from a materialized view using grouping sets.
The following example converts a binary value to a number: