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 NUMBER.
bin_to_num is useful in data warehousing applications for selecting groups of interest from a materialized view using grouping sets.