Description: BIN_TO_NUM converts a bit vector to its equivalent number. Each argument to this function represents a bit in the bit vector. This function takes as arguments any numeric datatype, or any nonnumeric datatype that can be implicitly converted to NUMBER. 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.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
BIN_TO_NUM(<value>,<value>,....)-- The following example converts a binary value to a number:SELECTBIN_TO_NUM(1,0,1,0)FROM DUAL;BIN_TO_NUM(1,0,1,0)-------------------10
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.
