|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 13 of 177
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: