|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 13 of 166
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: